
use scloud;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `sys_datasource_conf`
-- ----------------------------
DROP TABLE IF EXISTS `sys_datasource_conf`;
CREATE TABLE `sys_datasource_conf` (
                                     `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
                                     `name` varchar(255) DEFAULT NULL COMMENT '名称',
                                     `url` varchar(255) DEFAULT NULL,
                                     `username` varchar(255) DEFAULT NULL,
                                     `password` varchar(255) DEFAULT NULL,
                                     `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                     `update_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新',
                                     `del_flag` char(50) DEFAULT '0' COMMENT '删除标记',
                                     `tenant_id` int(11) DEFAULT NULL COMMENT '租户ID',
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据源表';

-- ----------------------------
-- Records of sys_datasource_conf
-- ----------------------------
INSERT INTO `sys_datasource_conf` VALUES ('3', 'scloud', 'jdbc:mysql://sc-mysql:3306/scloud?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&allowMultiQueries=true', 'root', '123456', '2019-03-31 16:40:43', '2019-04-11 20:57:06', '0', '1');
INSERT INTO `sys_datasource_conf` VALUES ('4', 'scloud_ac', 'jdbc:mysql://sc-mysql:3306/scloud_ac?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8', 'root', '123456', '2019-03-31 17:53:25', '2019-04-11 20:57:28', '0', '1');
INSERT INTO `sys_datasource_conf` VALUES ('5', 'scloud_job', 'jdbc:mysql://sc-mysql:3306/scloud_job?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8', 'root', '123456', '2019-03-31 17:53:25', '2019-04-11 20:57:54', '0', '1');
INSERT INTO `sys_datasource_conf` VALUES ('6', 'scloud_zipkin', 'jdbc:mysql://sc-mysql:3306/scloud_zipkin?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8', 'root', '123456', '2019-03-31 17:53:25', '2019-04-11 20:57:57', '0', '1');
INSERT INTO `sys_datasource_conf` VALUES ('9', 'scloud_', 'jdbc:mysql://sc-mysql:3306/scloud?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8', 'root', '123456', '2019-03-31 19:56:12', '2019-04-11 20:58:16', '0', '1');

-- ----------------------------
-- Table structure for `sys_dept`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
                          `dept_id` int(20) NOT NULL AUTO_INCREMENT,
                          `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
                          `sort` int(11) DEFAULT '1' COMMENT '排序',
                          `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                          `del_flag` char(1) DEFAULT '0' COMMENT '是否删除  -1：已删除  0：正常',
                          `parent_id` int(11) DEFAULT NULL,
                          `tenant_id` int(11) DEFAULT NULL,
                          `desccribe` varchar(200) DEFAULT NULL,
                          PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES ('0', '默认部门', '1', '2019-07-22 09:47:02', '2019-07-22 11:39:07', '0', '0', '0', '默认为超级管理员的部门');
INSERT INTO `sys_dept` VALUES ('1', '山东', '1', '2018-01-22 19:00:23', '2019-05-18 14:56:06', '0', '0', '1', null);
INSERT INTO `sys_dept` VALUES ('2', '沙县', '2', '2018-01-22 19:00:38', '2019-07-22 14:13:54', '0', '0', '1', null);
INSERT INTO `sys_dept` VALUES ('31', '指挥中心', '3', '2019-07-22 14:51:31', null, '0', '0', '5', null);
INSERT INTO `sys_dept` VALUES ('32', 'test', '2', '2019-07-22 17:07:02', '2019-07-22 17:07:08', '0', '31', '5', null);
INSERT INTO `sys_dept` VALUES ('33', 'test2', '1', '2019-07-22 17:07:15', null, '0', '32', '5', null);

-- ----------------------------
-- Table structure for `sys_dept_relation`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_relation`;
CREATE TABLE `sys_dept_relation` (
                                   `ancestor` int(11) NOT NULL COMMENT '祖先节点',
                                   `descendant` int(11) NOT NULL COMMENT '后代节点',
                                   PRIMARY KEY (`ancestor`,`descendant`) USING BTREE,
                                   KEY `idx1` (`ancestor`) USING BTREE,
                                   KEY `idx2` (`descendant`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='部门关系表';

-- ----------------------------
-- Records of sys_dept_relation
-- ----------------------------
INSERT INTO `sys_dept_relation` VALUES ('1', '1');
INSERT INTO `sys_dept_relation` VALUES ('2', '2');
INSERT INTO `sys_dept_relation` VALUES ('2', '16');
INSERT INTO `sys_dept_relation` VALUES ('2', '19');
INSERT INTO `sys_dept_relation` VALUES ('10', '10');
INSERT INTO `sys_dept_relation` VALUES ('13', '13');
INSERT INTO `sys_dept_relation` VALUES ('14', '14');
INSERT INTO `sys_dept_relation` VALUES ('15', '15');
INSERT INTO `sys_dept_relation` VALUES ('16', '16');
INSERT INTO `sys_dept_relation` VALUES ('16', '19');
INSERT INTO `sys_dept_relation` VALUES ('17', '17');
INSERT INTO `sys_dept_relation` VALUES ('18', '18');
INSERT INTO `sys_dept_relation` VALUES ('19', '19');
INSERT INTO `sys_dept_relation` VALUES ('20', '20');
INSERT INTO `sys_dept_relation` VALUES ('21', '21');
INSERT INTO `sys_dept_relation` VALUES ('22', '22');
INSERT INTO `sys_dept_relation` VALUES ('23', '23');
INSERT INTO `sys_dept_relation` VALUES ('24', '24');
INSERT INTO `sys_dept_relation` VALUES ('31', '31');
INSERT INTO `sys_dept_relation` VALUES ('31', '32');
INSERT INTO `sys_dept_relation` VALUES ('31', '33');
INSERT INTO `sys_dept_relation` VALUES ('32', '32');
INSERT INTO `sys_dept_relation` VALUES ('32', '33');
INSERT INTO `sys_dept_relation` VALUES ('33', '33');

-- ----------------------------
-- Table structure for `sys_dict`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
                          `id` int(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
                          `type` varchar(100) NOT NULL COMMENT '类型',
                          `description` varchar(100) NOT NULL COMMENT '描述',
                          `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                          `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
                          `system` char(1) NOT NULL DEFAULT '0' COMMENT '0-否|1-是',
                          `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
                          `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
                          PRIMARY KEY (`id`) USING BTREE,
                          KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES ('1', 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('2', 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('3', 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('4', 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('5', 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('6', 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('7', 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('8', 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('9', 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('10', 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('11', 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('12', 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('13', 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', '1');
INSERT INTO `sys_dict` VALUES ('14', 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('15', 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('16', 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('17', 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('18', 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('19', 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('20', 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('21', 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('22', 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('23', 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('24', 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('25', 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('26', 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', '2');
INSERT INTO `sys_dict` VALUES ('27', 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('28', 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('29', 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('30', 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('31', 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('32', 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('33', 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('34', 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('35', 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('36', 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('37', 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('38', 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('39', 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', '3');
INSERT INTO `sys_dict` VALUES ('40', 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('41', 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('42', 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('43', 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('44', 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('45', 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('46', 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('47', 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('48', 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('49', 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('50', 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('51', 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('52', 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', '4');
INSERT INTO `sys_dict` VALUES ('53', 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('54', 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('55', 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('56', 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('57', 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('58', 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('59', 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('60', 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('61', 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('62', 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('63', 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('64', 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', '5');
INSERT INTO `sys_dict` VALUES ('65', 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', '5');

-- ----------------------------
-- Table structure for `sys_dict_item`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item` (
                               `id` int(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
                               `dict_id` int(11) NOT NULL,
                               `value` varchar(100) NOT NULL COMMENT '数据值',
                               `label` varchar(100) NOT NULL COMMENT '标签名',
                               `type` varchar(100) NOT NULL COMMENT '类型',
                               `description` varchar(100) NOT NULL COMMENT '描述',
                               `sort` int(10) NOT NULL COMMENT '排序（升序）',
                               `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                               `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
                               `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
                               `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
                               PRIMARY KEY (`id`) USING BTREE,
                               KEY `sys_dict_value` (`value`) USING BTREE,
                               KEY `sys_dict_label` (`label`) USING BTREE,
                               KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='字典项';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
INSERT INTO `sys_dict_item` VALUES ('1', '1', '9', '异常', 'log_type', '日志异常', '1', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('2', '1', '0', '正常', 'log_type', '日志正常', '0', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('3', '2', 'WX', '微信', 'social_type', '微信登录', '0', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('4', '2', 'QQ', 'QQ', 'social_type', 'QQ登录', '1', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('5', '3', '0', '未提交', 'leave_status', '未提交', '0', '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('6', '3', '1', '审批中', 'leave_status', '审批中', '1', '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('7', '3', '2', '完成', 'leave_status', '完成', '2', '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('8', '3', '9', '驳回', 'leave_status', '驳回', '9', '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('9', '4', '1', 'java类', 'job_type', 'java类', '1', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('10', '4', '2', 'spring bean', 'job_type', 'spring bean容器实例', '2', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('11', '4', '9', '其他', 'job_type', '其他类型', '9', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('12', '4', '3', 'Rest 调用', 'job_type', 'Rest 调用', '3', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('13', '4', '4', 'jar', 'job_type', 'jar类型', '4', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('14', '5', '1', '未发布', 'job_status', '未发布', '1', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('15', '5', '2', '运行中', 'job_status', '运行中', '2', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('16', '5', '3', '暂停', 'job_status', '暂停', '3', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('17', '6', '0', '正常', 'job_execute_status', '正常', '0', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('18', '6', '1', '异常', 'job_execute_status', '异常', '1', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('19', '7', '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', '1', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('20', '7', '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', '2', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('21', '7', '3', '下周期执行', 'misfire_policy', '下周期执行', '3', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('22', '8', '1', '男', 'gender', '微信-男', '0', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('23', '8', '2', '女', 'gender', '女-微信', '1', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('24', '8', '0', '未知', 'gender', 'x性别未知', '3', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('25', '9', '0', '未关注', 'subscribe', '公众号-未关注', '0', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('26', '9', '1', '已关注', 'subscribe', '公众号-已关注', '1', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('27', '10', '0', '未回复', 'response_type', '微信消息-未回复', '0', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('28', '10', '1', '已回复', 'response_type', '微信消息-已回复', '1', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('29', '11', '1', '检索', 'param_type', '检索', '0', '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('30', '11', '2', '原文', 'param_type', '原文', '0', '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('31', '11', '3', '报表', 'param_type', '报表', '0', '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('32', '11', '4', '安全', 'param_type', '安全', '0', '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('33', '11', '5', '文档', 'param_type', '文档', '0', '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('34', '11', '6', '消息', 'param_type', '消息', '0', '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('35', '11', '9', '其他', 'param_type', '其他', '0', '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('36', '11', '0', '默认', 'param_type', '默认', '0', '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('37', '12', '0', '正常', 'status_type', '状态正常', '0', '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('38', '12', '9', '冻结', 'status_type', '状态冻结', '1', '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('39', '13', '1', '系统类', 'dict_type', '系统类字典', '0', '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('40', '13', '0', '业务类', 'dict_type', '业务类字典', '0', '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', '1');
INSERT INTO `sys_dict_item` VALUES ('41', '1', '9', '异常', 'log_type', '日志异常', '1', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('42', '1', '0', '正常', 'log_type', '日志正常', '0', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('43', '2', 'WX', '微信', 'social_type', '微信登录', '0', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('44', '2', 'QQ', 'QQ', 'social_type', 'QQ登录', '1', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('45', '3', '0', '未提交', 'leave_status', '未提交', '0', '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('46', '3', '1', '审批中', 'leave_status', '审批中', '1', '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('47', '3', '2', '完成', 'leave_status', '完成', '2', '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('48', '3', '9', '驳回', 'leave_status', '驳回', '9', '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('49', '4', '1', 'java类', 'job_type', 'java类', '1', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('50', '4', '2', 'spring bean', 'job_type', 'spring bean容器实例', '2', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('51', '4', '9', '其他', 'job_type', '其他类型', '9', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('52', '4', '3', 'Rest 调用', 'job_type', 'Rest 调用', '3', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('53', '4', '4', 'jar', 'job_type', 'jar类型', '4', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('54', '5', '1', '未发布', 'job_status', '未发布', '1', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('55', '5', '2', '运行中', 'job_status', '运行中', '2', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('56', '5', '3', '暂停', 'job_status', '暂停', '3', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('57', '6', '0', '正常', 'job_execute_status', '正常', '0', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('58', '6', '1', '异常', 'job_execute_status', '异常', '1', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('59', '7', '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', '1', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('60', '7', '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', '2', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('61', '7', '3', '下周期执行', 'misfire_policy', '下周期执行', '3', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('62', '8', '1', '男', 'gender', '微信-男', '0', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('63', '8', '2', '女', 'gender', '女-微信', '1', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('64', '8', '0', '未知', 'gender', 'x性别未知', '3', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('65', '9', '0', '未关注', 'subscribe', '公众号-未关注', '0', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('66', '9', '1', '已关注', 'subscribe', '公众号-已关注', '1', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('67', '10', '0', '未回复', 'response_type', '微信消息-未回复', '0', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('68', '10', '1', '已回复', 'response_type', '微信消息-已回复', '1', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('69', '11', '1', '检索', 'param_type', '检索', '0', '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('70', '11', '2', '原文', 'param_type', '原文', '0', '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('71', '11', '3', '报表', 'param_type', '报表', '0', '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('72', '11', '4', '安全', 'param_type', '安全', '0', '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('73', '11', '5', '文档', 'param_type', '文档', '0', '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('74', '11', '6', '消息', 'param_type', '消息', '0', '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('75', '11', '9', '其他', 'param_type', '其他', '0', '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('76', '11', '0', '默认', 'param_type', '默认', '0', '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('77', '12', '0', '正常', 'status_type', '状态正常', '0', '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('78', '12', '9', '冻结', 'status_type', '状态冻结', '1', '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('79', '13', '1', '系统类', 'dict_type', '系统类字典', '0', '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('80', '13', '0', '业务类', 'dict_type', '业务类字典', '0', '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', '2');
INSERT INTO `sys_dict_item` VALUES ('81', '1', '9', '异常', 'log_type', '日志异常', '1', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('82', '1', '0', '正常', 'log_type', '日志正常', '0', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('83', '2', 'WX', '微信', 'social_type', '微信登录', '0', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('84', '2', 'QQ', 'QQ', 'social_type', 'QQ登录', '1', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('85', '3', '0', '未提交', 'leave_status', '未提交', '0', '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('86', '3', '1', '审批中', 'leave_status', '审批中', '1', '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('87', '3', '2', '完成', 'leave_status', '完成', '2', '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('88', '3', '9', '驳回', 'leave_status', '驳回', '9', '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('89', '4', '1', 'java类', 'job_type', 'java类', '1', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('90', '4', '2', 'spring bean', 'job_type', 'spring bean容器实例', '2', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('91', '4', '9', '其他', 'job_type', '其他类型', '9', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('92', '4', '3', 'Rest 调用', 'job_type', 'Rest 调用', '3', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('93', '4', '4', 'jar', 'job_type', 'jar类型', '4', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('94', '5', '1', '未发布', 'job_status', '未发布', '1', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('95', '5', '2', '运行中', 'job_status', '运行中', '2', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('96', '5', '3', '暂停', 'job_status', '暂停', '3', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('97', '6', '0', '正常', 'job_execute_status', '正常', '0', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('98', '6', '1', '异常', 'job_execute_status', '异常', '1', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('99', '7', '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', '1', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('100', '7', '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', '2', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('101', '7', '3', '下周期执行', 'misfire_policy', '下周期执行', '3', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('102', '8', '1', '男', 'gender', '微信-男', '0', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('103', '8', '2', '女', 'gender', '女-微信', '1', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('104', '8', '0', '未知', 'gender', 'x性别未知', '3', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('105', '9', '0', '未关注', 'subscribe', '公众号-未关注', '0', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('106', '9', '1', '已关注', 'subscribe', '公众号-已关注', '1', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('107', '10', '0', '未回复', 'response_type', '微信消息-未回复', '0', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('108', '10', '1', '已回复', 'response_type', '微信消息-已回复', '1', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('109', '11', '1', '检索', 'param_type', '检索', '0', '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('110', '11', '2', '原文', 'param_type', '原文', '0', '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('111', '11', '3', '报表', 'param_type', '报表', '0', '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('112', '11', '4', '安全', 'param_type', '安全', '0', '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('113', '11', '5', '文档', 'param_type', '文档', '0', '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('114', '11', '6', '消息', 'param_type', '消息', '0', '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('115', '11', '9', '其他', 'param_type', '其他', '0', '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('116', '11', '0', '默认', 'param_type', '默认', '0', '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('117', '12', '0', '正常', 'status_type', '状态正常', '0', '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('118', '12', '9', '冻结', 'status_type', '状态冻结', '1', '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('119', '13', '1', '系统类', 'dict_type', '系统类字典', '0', '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('120', '13', '0', '业务类', 'dict_type', '业务类字典', '0', '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', '3');
INSERT INTO `sys_dict_item` VALUES ('121', '1', '9', '异常', 'log_type', '日志异常', '1', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('122', '1', '0', '正常', 'log_type', '日志正常', '0', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('123', '2', 'WX', '微信', 'social_type', '微信登录', '0', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('124', '2', 'QQ', 'QQ', 'social_type', 'QQ登录', '1', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('125', '3', '0', '未提交', 'leave_status', '未提交', '0', '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('126', '3', '1', '审批中', 'leave_status', '审批中', '1', '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('127', '3', '2', '完成', 'leave_status', '完成', '2', '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('128', '3', '9', '驳回', 'leave_status', '驳回', '9', '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('129', '4', '1', 'java类', 'job_type', 'java类', '1', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('130', '4', '2', 'spring bean', 'job_type', 'spring bean容器实例', '2', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('131', '4', '9', '其他', 'job_type', '其他类型', '9', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('132', '4', '3', 'Rest 调用', 'job_type', 'Rest 调用', '3', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('133', '4', '4', 'jar', 'job_type', 'jar类型', '4', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('134', '5', '1', '未发布', 'job_status', '未发布', '1', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('135', '5', '2', '运行中', 'job_status', '运行中', '2', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('136', '5', '3', '暂停', 'job_status', '暂停', '3', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('137', '6', '0', '正常', 'job_execute_status', '正常', '0', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('138', '6', '1', '异常', 'job_execute_status', '异常', '1', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('139', '7', '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', '1', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('140', '7', '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', '2', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('141', '7', '3', '下周期执行', 'misfire_policy', '下周期执行', '3', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('142', '8', '1', '男', 'gender', '微信-男', '0', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('143', '8', '2', '女', 'gender', '女-微信', '1', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('144', '8', '0', '未知', 'gender', 'x性别未知', '3', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('145', '9', '0', '未关注', 'subscribe', '公众号-未关注', '0', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('146', '9', '1', '已关注', 'subscribe', '公众号-已关注', '1', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('147', '10', '0', '未回复', 'response_type', '微信消息-未回复', '0', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('148', '10', '1', '已回复', 'response_type', '微信消息-已回复', '1', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('149', '11', '1', '检索', 'param_type', '检索', '0', '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('150', '11', '2', '原文', 'param_type', '原文', '0', '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('151', '11', '3', '报表', 'param_type', '报表', '0', '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('152', '11', '4', '安全', 'param_type', '安全', '0', '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('153', '11', '5', '文档', 'param_type', '文档', '0', '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('154', '11', '6', '消息', 'param_type', '消息', '0', '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('155', '11', '9', '其他', 'param_type', '其他', '0', '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('156', '11', '0', '默认', 'param_type', '默认', '0', '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('157', '12', '0', '正常', 'status_type', '状态正常', '0', '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('158', '12', '9', '冻结', 'status_type', '状态冻结', '1', '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('159', '13', '1', '系统类', 'dict_type', '系统类字典', '0', '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('160', '13', '0', '业务类', 'dict_type', '业务类字典', '0', '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', '4');
INSERT INTO `sys_dict_item` VALUES ('161', '1', '9', '异常', 'log_type', '日志异常', '1', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('162', '1', '0', '正常', 'log_type', '日志正常', '0', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('163', '2', 'WX', '微信', 'social_type', '微信登录', '0', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('164', '2', 'QQ', 'QQ', 'social_type', 'QQ登录', '1', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('165', '3', '0', '未提交', 'leave_status', '未提交', '0', '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('166', '3', '1', '审批中', 'leave_status', '审批中', '1', '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('167', '3', '2', '完成', 'leave_status', '完成', '2', '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('168', '3', '9', '驳回', 'leave_status', '驳回', '9', '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('169', '4', '1', 'java类', 'job_type', 'java类', '1', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('170', '4', '2', 'spring bean', 'job_type', 'spring bean容器实例', '2', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('171', '4', '9', '其他', 'job_type', '其他类型', '9', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('172', '4', '3', 'Rest 调用', 'job_type', 'Rest 调用', '3', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('173', '4', '4', 'jar', 'job_type', 'jar类型', '4', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('174', '5', '1', '未发布', 'job_status', '未发布', '1', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('175', '5', '2', '运行中', 'job_status', '运行中', '2', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('176', '5', '3', '暂停', 'job_status', '暂停', '3', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('177', '6', '0', '正常', 'job_execute_status', '正常', '0', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('178', '6', '1', '异常', 'job_execute_status', '异常', '1', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('179', '7', '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', '1', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('180', '7', '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', '2', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('181', '7', '3', '下周期执行', 'misfire_policy', '下周期执行', '3', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('182', '8', '1', '男', 'gender', '微信-男', '0', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('183', '8', '2', '女', 'gender', '女-微信', '1', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('184', '8', '0', '未知', 'gender', 'x性别未知', '3', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('185', '9', '0', '未关注', 'subscribe', '公众号-未关注', '0', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('186', '9', '1', '已关注', 'subscribe', '公众号-已关注', '1', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('187', '10', '0', '未回复', 'response_type', '微信消息-未回复', '0', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('188', '10', '1', '已回复', 'response_type', '微信消息-已回复', '1', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('189', '11', '1', '检索', 'param_type', '检索', '0', '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('190', '11', '2', '原文', 'param_type', '原文', '0', '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('191', '11', '3', '报表', 'param_type', '报表', '0', '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('192', '11', '4', '安全', 'param_type', '安全', '0', '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('193', '11', '5', '文档', 'param_type', '文档', '0', '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('194', '11', '6', '消息', 'param_type', '消息', '0', '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('195', '11', '9', '其他', 'param_type', '其他', '0', '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('196', '11', '0', '默认', 'param_type', '默认', '0', '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('197', '12', '0', '正常', 'status_type', '状态正常', '0', '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('198', '12', '9', '冻结', 'status_type', '状态冻结', '1', '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('199', '13', '1', '系统类', 'dict_type', '系统类字典', '0', '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', '5');
INSERT INTO `sys_dict_item` VALUES ('200', '13', '0', '业务类', 'dict_type', '业务类字典', '0', '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', '5');

-- ----------------------------
-- Table structure for `sys_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
                         `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
                         `type` char(1) DEFAULT '1' COMMENT '日志类型',
                         `title` varchar(255) DEFAULT '' COMMENT '日志标题',
                         `service_id` varchar(32) DEFAULT NULL COMMENT '服务ID',
                         `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
                         `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                         `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                         `remote_addr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
                         `user_agent` varchar(1000) DEFAULT NULL COMMENT '用户代理',
                         `request_uri` varchar(255) DEFAULT NULL COMMENT '请求URI',
                         `method` varchar(10) DEFAULT NULL COMMENT '操作方式',
                         `params` text COMMENT '操作提交的数据',
                         `time` mediumtext COMMENT '执行时间',
                         `del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
                         `exception` text COMMENT '异常信息',
                         `tenant_id` int(11) DEFAULT '0' COMMENT '所属租户',
                         PRIMARY KEY (`id`) USING BTREE,
                         KEY `sys_log_create_by` (`create_by`) USING BTREE,
                         KEY `sys_log_request_uri` (`request_uri`) USING BTREE,
                         KEY `sys_log_type` (`type`) USING BTREE,
                         KEY `sys_log_create_date` (`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='日志表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES ('2', '0', '更新用户信息', 'sc', 'admin', '2019-07-19 15:21:02', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'PUT', '', '408', '0', null, '1');
INSERT INTO `sys_log` VALUES ('3', '0', '新增租户', 'sc', 'admin', '2019-07-19 15:24:43', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/tenant', 'POST', '', '377', '0', null, '3');
INSERT INTO `sys_log` VALUES ('4', '0', '删除租户', 'sc', 'admin', '2019-07-19 15:24:48', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/tenant/2', 'DELETE', '', '105', '0', null, '1');
INSERT INTO `sys_log` VALUES ('5', '0', '删除部门', 'sc', 'admin', '2019-07-19 15:26:49', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/12', 'DELETE', '', '282', '0', null, '1');
INSERT INTO `sys_log` VALUES ('6', '0', '删除部门', 'sc', 'admin', '2019-07-19 15:26:52', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/11', 'DELETE', '', '193', '0', null, '1');
INSERT INTO `sys_log` VALUES ('7', '0', '删除部门', 'sc', 'admin', '2019-07-19 15:26:54', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/8', 'DELETE', '', '121', '0', null, '1');
INSERT INTO `sys_log` VALUES ('8', '0', '删除部门', 'sc', 'admin', '2019-07-19 15:26:57', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/7', 'DELETE', '', '188', '0', null, '1');
INSERT INTO `sys_log` VALUES ('9', '0', '添加部门', 'sc', 'admin', '2019-07-19 15:29:54', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '6', '0', null, '1');
INSERT INTO `sys_log` VALUES ('10', '0', '添加部门', 'sc', 'admin', '2019-07-19 15:33:37', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', '/dept', 'POST', '', '3', '0', null, '1');
INSERT INTO `sys_log` VALUES ('11', '0', '添加部门', 'sc', 'admin', '2019-07-19 15:35:58', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', '/dept', 'POST', '', '102273', '0', null, '1');
INSERT INTO `sys_log` VALUES ('12', '0', '添加部门', 'sc', 'admin', '2019-07-19 15:38:53', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', '/dept', 'POST', '', '4908', '0', null, '1');
INSERT INTO `sys_log` VALUES ('13', '0', '添加部门', 'sc', 'admin', '2019-07-19 16:11:13', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', '/dept', 'POST', '', '4', '0', null, '1');
INSERT INTO `sys_log` VALUES ('14', '0', '添加部门', 'sc', 'admin', '2019-07-19 16:12:50', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', '/dept', 'POST', '', '23312', '0', null, '1');
INSERT INTO `sys_log` VALUES ('15', '0', '编辑部门', 'sc', 'admin', '2019-07-19 16:37:06', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', '/dept', 'PUT', '', '194', '0', null, '1');
INSERT INTO `sys_log` VALUES ('16', '0', '新增租户', 'sc', 'admin', '2019-07-19 17:27:07', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/tenant', 'POST', '', '487', '0', null, '4');
INSERT INTO `sys_log` VALUES ('17', '0', '添加角色', 'sc', 'admin', '2019-07-19 17:27:21', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'POST', '', '190', '0', null, '1');
INSERT INTO `sys_log` VALUES ('18', '0', '添加用户', 'sc', 'admin', '2019-07-19 17:44:58', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'POST', '', '317', '0', null, '1');
INSERT INTO `sys_log` VALUES ('19', '0', '添加部门', 'sc', 'admin', '2019-07-19 17:45:51', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '4251', '0', null, '1');
INSERT INTO `sys_log` VALUES ('20', '0', '添加部门', 'sc', 'admin', '2019-07-19 18:55:23', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '210', '0', null, '1');
INSERT INTO `sys_log` VALUES ('21', '0', '添加部门', 'sc', 'admin', '2019-07-19 18:56:05', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '160', '0', null, '1');
INSERT INTO `sys_log` VALUES ('22', '0', '添加部门', 'sc', 'admin', '2019-07-19 18:57:21', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '34555', '0', null, '1');
INSERT INTO `sys_log` VALUES ('23', '0', '添加部门', 'sc', 'admin', '2019-07-22 09:34:36', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '326', '0', null, '1');
INSERT INTO `sys_log` VALUES ('24', '0', '修改三方信息', 'sc', 'admin', '2019-07-22 09:37:16', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/social', 'PUT', '', '233', '0', null, '1');
INSERT INTO `sys_log` VALUES ('25', '0', '删除菜单', 'sc', 'admin', '2019-07-22 09:38:07', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/menu/3400', 'DELETE', '', '183', '0', null, '1');
INSERT INTO `sys_log` VALUES ('26', '0', '删除菜单', 'sc', 'admin', '2019-07-22 09:38:12', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/menu/3300', 'DELETE', '', '102', '0', null, '1');
INSERT INTO `sys_log` VALUES ('27', '0', '添加角色', 'sc', 'admin', '2019-07-22 09:41:39', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'POST', '', '200', '0', null, '1');
INSERT INTO `sys_log` VALUES ('28', '0', '添加部门', 'sc', 'admin', '2019-07-22 09:43:11', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '242', '0', null, '1');
INSERT INTO `sys_log` VALUES ('29', '0', '删除部门', 'sc', 'admin', '2019-07-22 09:44:25', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/5', 'DELETE', '', '233', '0', null, '1');
INSERT INTO `sys_log` VALUES ('30', '0', '删除部门', 'sc', 'admin', '2019-07-22 09:44:28', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/4', 'DELETE', '', '112', '0', null, '1');
INSERT INTO `sys_log` VALUES ('31', '0', '删除部门', 'sc', 'admin', '2019-07-22 09:44:31', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/3', 'DELETE', '', '105', '0', null, '1');
INSERT INTO `sys_log` VALUES ('32', '0', '删除租户', 'sc', 'admin', '2019-07-22 09:44:59', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/tenant/4', 'DELETE', '', '142', '0', null, '1');
INSERT INTO `sys_log` VALUES ('33', '0', '新增租户', 'sc', 'admin', '2019-07-22 09:46:07', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/tenant', 'POST', '', '504', '0', null, '5');
INSERT INTO `sys_log` VALUES ('34', '0', '添加部门', 'sc', 'admin', '2019-07-22 09:47:02', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '321', '0', null, '1');
INSERT INTO `sys_log` VALUES ('35', '0', '添加用户', 'sc', 'admin', '2019-07-22 09:47:41', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'POST', '', '299', '0', null, '1');
INSERT INTO `sys_log` VALUES ('36', '0', '更新角色菜单', 'sc', 'admin', '2019-07-22 09:50:25', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B6%5D&menuIds=%5B1000%2C1100%2C1101%2C1102%2C1103%2C1200%2C1203%2C1201%2C1202%2C1300%2C1301%2C1302%2C1303%2C1304%2C1400%2C1402%2C1401%2C1403%2C1500%2C1501%2C1502%2C1503%2C%5D', '295', '0', null, '1');
INSERT INTO `sys_log` VALUES ('37', '0', '删除租户', 'sc', 'superadmin', '2019-07-22 09:57:47', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/tenant/5', 'DELETE', '', '225', '0', null, '1');
INSERT INTO `sys_log` VALUES ('38', '0', '更新角色菜单', 'sc', 'superadmin', '2019-07-22 10:03:58', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B6%5D&menuIds=%5B1000%2C1100%2C1101%2C1102%2C1103%2C1200%2C1203%2C1201%2C1202%2C1300%2C1301%2C1302%2C1303%2C1304%2C1400%2C1402%2C1401%2C1403%2C1500%2C1501%2C1502%2C1503%2C2000%2C2100%2C2101%2C2200%2C2202%2C2203%2C2201%2C2210%2C2213%2C2211%2C2212%2C2800%2C2850%2C2840%2C2810%2C2860%2C2830%2C2820%2C2300%2C2400%2C2401%2C2402%2C2403%2C2500%2C2501%2C2502%2C2503%2C2600%2C2601%2C2700%2C3000%2C3100%2C3110%2C3200%2C3500%2C3630%2C3600%2C3601%2C3620%2C4000%2C4100%2C4101%2C4102%2C4103%2C4104%2C4105%2C4106%2C4107%2C%5D', '264', '0', null, '1');
INSERT INTO `sys_log` VALUES ('39', '0', '添加部门', 'sc', 'superadmin', '2019-07-22 13:42:54', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '210', '0', null, '1');
INSERT INTO `sys_log` VALUES ('40', '0', '修改角色', 'sc', 'superadmin', '2019-07-22 14:06:53', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'PUT', '', '171', '0', null, '1');
INSERT INTO `sys_log` VALUES ('41', '0', '删除部门', 'sc', 'superadmin', '2019-07-22 14:14:16', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/25', 'DELETE', '', '223', '0', null, '1');
INSERT INTO `sys_log` VALUES ('42', '0', '添加部门', 'sc', 'superadmin', '2019-07-22 14:16:51', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '263', '0', null, '1');
INSERT INTO `sys_log` VALUES ('43', '0', '删除部门', 'sc', 'superadmin', '2019-07-22 14:17:37', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/26', 'DELETE', '', '229', '0', null, '1');
INSERT INTO `sys_log` VALUES ('44', '0', '删除部门', 'sc', 'superadmin', '2019-07-22 14:26:56', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/27', 'DELETE', '', '218', '0', null, '1');
INSERT INTO `sys_log` VALUES ('45', '0', '添加部门', 'sc', 'superadmin', '2019-07-22 14:27:39', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '8294', '0', null, '1');
INSERT INTO `sys_log` VALUES ('46', '0', '添加部门', 'sc', 'superadmin', '2019-07-22 14:28:10', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '7131', '0', null, '1');
INSERT INTO `sys_log` VALUES ('47', '0', '添加部门', 'sc', 'superadmin', '2019-07-22 14:41:40', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '7627', '0', null, '1');
INSERT INTO `sys_log` VALUES ('48', '0', '删除部门', 'sc', 'superadmin', '2019-07-22 14:50:55', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/29', 'DELETE', '', '273', '0', null, '1');
INSERT INTO `sys_log` VALUES ('49', '0', '删除部门', 'sc', 'superadmin', '2019-07-22 14:50:57', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/28', 'DELETE', '', '98', '0', null, '1');
INSERT INTO `sys_log` VALUES ('50', '0', '删除部门', 'sc', 'superadmin', '2019-07-22 14:50:59', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept/30', 'DELETE', '', '96', '0', null, '1');
INSERT INTO `sys_log` VALUES ('51', '0', '添加部门', 'sc', 'superadmin', '2019-07-22 14:51:31', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '3152', '0', null, '1');
INSERT INTO `sys_log` VALUES ('52', '0', '添加角色', 'sc', 'superadmin', '2019-07-22 14:52:05', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'POST', '', '197', '0', null, '1');
INSERT INTO `sys_log` VALUES ('53', '0', '更新角色菜单', 'sc', 'superadmin', '2019-07-22 14:52:16', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B8%5D&menuIds=%5B4000%2C4100%2C4101%2C4102%2C4103%2C4104%2C4105%2C4106%2C4107%2C%5D', '275', '0', null, '1');
INSERT INTO `sys_log` VALUES ('54', '0', '添加用户', 'sc', 'superadmin', '2019-07-22 14:52:38', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'POST', '', '358', '0', null, '1');
INSERT INTO `sys_log` VALUES ('55', '0', '更新角色菜单', 'sc', 'superadmin', '2019-07-22 15:31:33', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B8%5D&menuIds=%5B4000%2C4100%2C4101%2C4102%2C4103%2C4104%2C4105%2C4106%2C4107%2C%5D', '308', '0', null, '1');
INSERT INTO `sys_log` VALUES ('56', '0', '修改角色', 'sc', 'superadmin', '2019-07-22 15:31:48', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'PUT', '', '16', '0', null, '1');
INSERT INTO `sys_log` VALUES ('57', '0', '更新角色菜单', 'sc', 'superadmin', '2019-07-22 15:32:12', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B8%5D&menuIds=%5B1100%2C1101%2C1102%2C1103%2C1200%2C1203%2C1201%2C1202%2C1300%2C1301%2C1302%2C1303%2C1304%2C1400%2C1402%2C1401%2C1403%2C4000%2C4100%2C4101%2C4102%2C4103%2C4104%2C4105%2C4106%2C4107%2C1000%5D', '318', '0', null, '1');
INSERT INTO `sys_log` VALUES ('58', '0', '更新角色菜单', 'sc', 'superadmin', '2019-07-22 15:37:30', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B8%5D&menuIds=%5B1000%2C1100%2C1101%2C1102%2C1103%2C1200%2C1203%2C1201%2C1202%2C1300%2C1301%2C1302%2C1303%2C1304%2C1400%2C1402%2C1401%2C1403%2C1500%2C1501%2C1502%2C1503%2C2200%2C2202%2C2203%2C2201%2C4000%2C4100%2C4101%2C4102%2C4103%2C4104%2C4105%2C4106%2C4107%2C2000%5D', '237', '0', null, '1');
INSERT INTO `sys_log` VALUES ('59', '0', '添加用户', 'sc', 'ucpadmin', '2019-07-22 15:45:55', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'POST', '', '340', '0', null, '1');
INSERT INTO `sys_log` VALUES ('60', '0', '更新用户信息', 'sc', 'superadmin', '2019-07-22 16:44:29', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'PUT', '', '503', '0', null, '1');
INSERT INTO `sys_log` VALUES ('61', '0', '更新用户信息', 'sc', 'superadmin', '2019-07-22 16:44:56', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'PUT', '', '448', '0', null, '1');
INSERT INTO `sys_log` VALUES ('62', '0', '添加角色', 'sc', 'ucpadmin', '2019-07-22 17:06:19', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'POST', '', '256', '0', null, '1');
INSERT INTO `sys_log` VALUES ('63', '0', '添加部门', 'sc', 'ucpadmin', '2019-07-22 17:07:02', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '216', '0', null, '1');
INSERT INTO `sys_log` VALUES ('64', '0', '编辑部门', 'sc', 'ucpadmin', '2019-07-22 17:07:07', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'PUT', '', '111', '0', null, '1');
INSERT INTO `sys_log` VALUES ('65', '0', '添加部门', 'sc', 'ucpadmin', '2019-07-22 17:07:15', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/dept', 'POST', '', '211', '0', null, '1');
INSERT INTO `sys_log` VALUES ('66', '0', '更新角色菜单', 'sc', 'ucpadmin', '2019-07-22 17:07:34', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role/menu', 'PUT', 'roleId=%5B8%5D&menuIds=%5B1100%2C1101%2C1102%2C1103%2C1200%2C1203%2C1201%2C1202%2C1300%2C1301%2C1302%2C1303%2C1304%2C1400%2C1402%2C1401%2C1403%2C2200%2C2202%2C2203%2C2201%2C4000%2C4100%2C4101%2C4102%2C4103%2C4104%2C4105%2C4106%2C4107%2C1000%2C2000%5D', '281', '0', null, '1');
INSERT INTO `sys_log` VALUES ('67', '0', '添加角色', 'sc', 'ucpadmin', '2019-07-22 17:14:21', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'POST', '', '13633', '0', null, '1');
INSERT INTO `sys_log` VALUES ('68', '0', '添加角色', 'sc', 'ucpadmin', '2019-07-22 17:15:37', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/role', 'POST', '', '304', '0', null, '1');
INSERT INTO `sys_log` VALUES ('69', '0', '添加用户', 'sc', 'ucpadmin', '2019-07-22 17:16:32', null, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3719.400 QQBrowser/10.5.3715.400', '/user', 'POST', '', '288', '0', null, '1');

-- ----------------------------
-- Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
                          `menu_id` int(11) NOT NULL COMMENT '菜单ID',
                          `name` varchar(32) NOT NULL COMMENT '菜单名称',
                          `permission` varchar(32) DEFAULT NULL COMMENT '菜单权限标识',
                          `path` varchar(128) DEFAULT NULL COMMENT '前端URL',
                          `parent_id` int(11) DEFAULT NULL COMMENT '父菜单ID',
                          `icon` varchar(32) DEFAULT NULL COMMENT '图标',
                          `component` varchar(64) DEFAULT NULL COMMENT 'VUE页面',
                          `sort` int(11) DEFAULT '1' COMMENT '排序值',
                          `keep_alive` char(1) DEFAULT '0' COMMENT '0-开启，1- 关闭',
                          `type` char(1) DEFAULT NULL COMMENT '菜单类型 （0菜单 1按钮）',
                          `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                          `del_flag` char(1) DEFAULT '0' COMMENT '逻辑删除标记(0--正常 1--删除)',
                          PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1000', '权限管理', null, '/upms', '-1', 'icon-guanfangbanben', 'Layout', '0', '0', '0', '2018-09-28 08:29:53', '2019-07-19 09:25:28', '0');
INSERT INTO `sys_menu` VALUES ('1100', '用户管理', null, 'user', '1000', 'icon-yonghuguanli', 'views/admin/user/index', '1', '1', '0', '2017-11-02 22:24:37', '2018-09-28 09:00:41', '0');
INSERT INTO `sys_menu` VALUES ('1101', '用户新增', 'sys_user_add', null, '1100', null, null, null, '0', '1', '2017-11-08 09:52:09', '2018-09-28 09:06:34', '0');
INSERT INTO `sys_menu` VALUES ('1102', '用户修改', 'sys_user_edit', null, '1100', null, null, null, '0', '1', '2017-11-08 09:52:48', '2018-09-28 09:06:37', '0');
INSERT INTO `sys_menu` VALUES ('1103', '用户删除', 'sys_user_del', null, '1100', null, null, null, '0', '1', '2017-11-08 09:54:01', '2018-09-28 09:06:42', '0');
INSERT INTO `sys_menu` VALUES ('1200', '菜单管理', null, 'menu', '1000', 'icon-caidanguanli', 'views/admin/menu/index', '2', '0', '0', '2017-11-08 09:57:27', '2018-09-28 09:00:45', '0');
INSERT INTO `sys_menu` VALUES ('1201', '菜单新增', 'sys_menu_add', null, '1200', null, null, null, '0', '1', '2017-11-08 10:15:53', '2018-09-28 09:07:16', '0');
INSERT INTO `sys_menu` VALUES ('1202', '菜单修改', 'sys_menu_edit', null, '1200', null, null, null, '0', '1', '2017-11-08 10:16:23', '2018-09-28 09:07:18', '0');
INSERT INTO `sys_menu` VALUES ('1203', '菜单删除', 'sys_menu_del', null, '1200', null, null, null, '0', '1', '2017-11-08 10:16:43', '2018-09-28 09:07:22', '0');
INSERT INTO `sys_menu` VALUES ('1300', '角色管理', null, 'role', '1000', 'icon-jiaoseguanli', 'views/admin/role/index', '3', '0', '0', '2017-11-08 10:13:37', '2018-09-28 09:00:48', '0');
INSERT INTO `sys_menu` VALUES ('1301', '角色新增', 'sys_role_add', null, '1300', null, null, null, '0', '1', '2017-11-08 10:14:18', '2018-09-28 09:07:46', '0');
INSERT INTO `sys_menu` VALUES ('1302', '角色修改', 'sys_role_edit', null, '1300', null, null, null, '0', '1', '2017-11-08 10:14:41', '2018-09-28 09:07:49', '0');
INSERT INTO `sys_menu` VALUES ('1303', '角色删除', 'sys_role_del', null, '1300', null, null, null, '0', '1', '2017-11-08 10:14:59', '2018-09-28 09:07:53', '0');
INSERT INTO `sys_menu` VALUES ('1304', '分配权限', 'sys_role_perm', null, '1300', null, null, null, '0', '1', '2018-04-20 07:22:55', '2018-09-28 09:13:23', '0');
INSERT INTO `sys_menu` VALUES ('1400', '部门管理', null, 'dept', '1000', 'icon-zhexiantu', 'views/admin/dept/index', '4', '0', '0', '2018-01-20 13:17:19', '2019-07-19 09:25:50', '0');
INSERT INTO `sys_menu` VALUES ('1401', '部门新增', 'sys_dept_add', null, '1400', null, null, null, '0', '1', '2018-01-20 14:56:16', '2018-09-28 09:08:13', '0');
INSERT INTO `sys_menu` VALUES ('1402', '部门修改', 'sys_dept_edit', null, '1400', null, null, null, '0', '1', '2018-01-20 14:56:59', '2018-09-28 09:08:16', '0');
INSERT INTO `sys_menu` VALUES ('1403', '部门删除', 'sys_dept_del', null, '1400', null, null, null, '0', '1', '2018-01-20 14:57:28', '2018-09-28 09:08:18', '0');
INSERT INTO `sys_menu` VALUES ('1500', '类别管理', '', 'systenant', '1000', 'icon-relationship', 'views/admin/tenant/index', '5', '0', '0', '2018-01-20 13:17:19', '2019-07-19 09:26:23', '0');
INSERT INTO `sys_menu` VALUES ('1501', '类别新增', 'admin_systenant_add', null, '1500', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-07-19 09:26:24', '0');
INSERT INTO `sys_menu` VALUES ('1502', '类别修改', 'admin_systenant_edit', null, '1500', '1', null, '1', '0', '1', '2018-05-15 21:35:18', '2019-07-19 09:26:26', '0');
INSERT INTO `sys_menu` VALUES ('1503', '类别删除', 'admin_systenant_del', null, '1500', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-07-19 09:26:29', '0');
INSERT INTO `sys_menu` VALUES ('2000', '系统管理', null, '/admin', '-1', 'icon-xitongguanli', 'Layout', '1', '0', '0', '2017-11-07 20:56:00', '2018-09-28 08:53:18', '0');
INSERT INTO `sys_menu` VALUES ('2100', '日志管理', null, 'log', '2000', 'icon-rizhiguanli', 'views/admin/log/index', '5', '0', '0', '2017-11-20 14:06:22', '2018-09-28 09:01:52', '0');
INSERT INTO `sys_menu` VALUES ('2101', '日志删除', 'sys_log_del', null, '2100', null, null, null, '0', '1', '2017-11-20 20:37:37', '2018-09-28 09:08:44', '0');
INSERT INTO `sys_menu` VALUES ('2200', '字典管理', null, 'dict', '2000', 'icon-icon_shiyongwendang', 'views/admin/dict/index', '6', '0', '0', '2017-11-29 11:30:52', '2019-07-19 09:26:54', '0');
INSERT INTO `sys_menu` VALUES ('2201', '字典删除', 'sys_dict_del', null, '2200', null, null, null, '0', '1', '2017-11-29 11:30:11', '2018-09-28 09:09:10', '0');
INSERT INTO `sys_menu` VALUES ('2202', '字典新增', 'sys_dict_add', null, '2200', null, null, null, '0', '1', '2018-05-11 22:34:55', '2018-09-28 09:09:12', '0');
INSERT INTO `sys_menu` VALUES ('2203', '字典修改', 'sys_dict_edit', null, '2200', null, null, null, '0', '1', '2018-05-11 22:36:03', '2018-09-28 09:09:16', '0');
INSERT INTO `sys_menu` VALUES ('2210', '参数管理', null, 'param', '2000', 'icon-canshu', 'views/admin/param/index', '7', '1', '0', '2019-04-29 22:16:50', null, '0');
INSERT INTO `sys_menu` VALUES ('2211', '参数新增', 'admin_syspublicparam_add', null, '2210', null, null, '1', '0', '1', '2019-04-29 22:17:36', null, '0');
INSERT INTO `sys_menu` VALUES ('2212', '参数删除', 'admin_syspublicparam_del', null, '2210', null, null, '1', '0', '1', '2019-04-29 22:17:55', null, '0');
INSERT INTO `sys_menu` VALUES ('2213', '参数编辑', 'admin_syspublicparam_edit', null, '2210', null, null, '1', '0', '1', '2019-04-29 22:18:14', '2019-04-29 22:19:25', '0');
INSERT INTO `sys_menu` VALUES ('2300', '代码生成', '', 'gen', '2000', 'icon-xiyiji', 'views/gen/index', '8', '0', '0', '2018-01-20 13:17:19', '2019-07-19 09:28:39', '0');
INSERT INTO `sys_menu` VALUES ('2400', '终端管理', '', 'client', '2000', 'icon-shouji', 'views/admin/client/index', '9', '0', '0', '2018-01-20 13:17:19', '2018-09-28 09:01:43', '0');
INSERT INTO `sys_menu` VALUES ('2401', '客户端新增', 'sys_client_add', null, '2400', '1', null, null, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:10:25', '0');
INSERT INTO `sys_menu` VALUES ('2402', '客户端修改', 'sys_client_edit', null, '2400', null, null, null, '0', '1', '2018-05-15 21:37:06', '2018-09-28 09:10:27', '0');
INSERT INTO `sys_menu` VALUES ('2403', '客户端删除', 'sys_client_del', null, '2400', null, null, null, '0', '1', '2018-05-15 21:39:16', '2018-09-28 09:10:30', '0');
INSERT INTO `sys_menu` VALUES ('2500', '密钥管理', '', 'social', '2000', 'icon-miyue', 'views/admin/social/index', '10', '0', '0', '2018-01-20 13:17:19', '2018-09-28 09:01:41', '0');
INSERT INTO `sys_menu` VALUES ('2501', '密钥新增', 'sys_social_details_add', null, '2500', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:52:18', '0');
INSERT INTO `sys_menu` VALUES ('2502', '密钥修改', 'sys_social_details_edit', null, '2500', '1', null, '1', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:51:36', '0');
INSERT INTO `sys_menu` VALUES ('2503', '密钥删除', 'sys_social_details_del', null, '2500', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:51:30', '0');
INSERT INTO `sys_menu` VALUES ('2600', '令牌管理', null, 'token', '2000', 'icon-huowudui1', 'views/admin/token/index', '11', '0', '0', '2018-09-04 05:58:41', '2019-07-19 09:28:00', '0');
INSERT INTO `sys_menu` VALUES ('2601', '令牌删除', 'sys_token_del', null, '2600', null, null, '1', '0', '1', '2018-09-04 05:59:50', '2018-09-28 09:11:24', '0');
INSERT INTO `sys_menu` VALUES ('2700', '动态路由', null, 'route', '2000', 'icon-luyou', 'views/admin/route/index', '12', '0', '0', '2018-09-04 05:58:41', '2018-09-28 09:01:38', '0');
INSERT INTO `sys_menu` VALUES ('2800', 'Quartz管理', '', 'job-manage', '2000', 'icon-guanwangfangwen', 'views/daemon/job-manage/index', '8', '0', '0', '2018-01-20 13:17:19', '2019-03-25 13:52:14', '0');
INSERT INTO `sys_menu` VALUES ('2810', '任务新增', 'job_sys_job_add', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:23', '0');
INSERT INTO `sys_menu` VALUES ('2820', '任务修改', 'job_sys_job_edit', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:26', '0');
INSERT INTO `sys_menu` VALUES ('2830', '任务删除', 'job_sys_job_del', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:30', '0');
INSERT INTO `sys_menu` VALUES ('2840', '任务暂停', 'job_sys_job_shutdown_job', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:18', '0');
INSERT INTO `sys_menu` VALUES ('2850', '任务开始', 'job_sys_job_start_job', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:35', '0');
INSERT INTO `sys_menu` VALUES ('2860', '任务刷新', 'job_sys_job_refresh_job', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:39', '0');
INSERT INTO `sys_menu` VALUES ('3000', '系统监控', null, '/daemon', '-1', 'icon-msnui-supervise', 'Layout', '2', '0', '0', '2018-07-27 01:13:21', '2018-09-28 08:53:24', '0');
INSERT INTO `sys_menu` VALUES ('3100', '服务监控', null, 'http://127.0.0.1:5001', '3000', 'icon-server', null, '0', '0', '0', '2018-06-26 10:50:32', '2019-05-01 23:54:05', '0');
INSERT INTO `sys_menu` VALUES ('3110', '缓存监控', null, 'redis', '3000', 'icon-qingchuhuancun', 'views/monitor/redis/index', '1', '1', '0', '2019-05-08 23:51:27', '2019-05-08 23:52:23', '0');
INSERT INTO `sys_menu` VALUES ('3200', '接口文档', null, 'http://127.0.0.1:9999/swagger-ui.html', '3000', 'icon-wendang', null, '1', '0', '0', '2018-06-26 10:50:32', '2019-05-01 23:57:11', '0');
INSERT INTO `sys_menu` VALUES ('3300', '事务监控', null, 'tx', '3000', 'icon-gtsquanjushiwufuwuGTS', 'views/tx/index', '5', '0', '0', '2018-08-19 11:02:39', '2019-07-22 09:38:12', '1');
INSERT INTO `sys_menu` VALUES ('3400', '在线事务', null, 'model', '3000', 'icon-online', 'views/tx/model', '6', '0', '0', '2018-08-19 11:32:04', '2019-07-22 09:38:07', '1');
INSERT INTO `sys_menu` VALUES ('3500', '文档扩展', null, 'http://127.0.0.1:9999/doc.html', '3000', 'icon-wendang', null, '2', '0', '0', '2018-06-26 10:50:32', '2019-05-01 23:57:42', '0');
INSERT INTO `sys_menu` VALUES ('3600', '任务轨迹', '', 'status-trace-log', '3000', 'icon-guiji', 'views/daemon/status-trace-log/index', '8', '0', '0', '2018-01-20 13:17:19', '2018-11-24 06:34:52', '0');
INSERT INTO `sys_menu` VALUES ('3601', '删除轨迹', 'daemon_status_trace_log_del', null, '3600', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-03-30 09:31:06', '0');
INSERT INTO `sys_menu` VALUES ('3620', 'Quartz日志', '', 'joblog', '3000', 'icon-gtsquanjushiwufuwuGTS', 'views/daemon/job-log/index', '8', '0', '0', '2018-01-20 13:17:19', '2019-03-25 11:49:36', '0');
INSERT INTO `sys_menu` VALUES ('3630', '任务日志', '', 'execution-log', '3000', 'icon-wendang', 'views/daemon/execution-log/index', '7', '0', '0', '2018-01-20 13:17:19', '2019-03-30 09:30:33', '0');
INSERT INTO `sys_menu` VALUES ('3631', '删除日志', 'daemon_execution_log_del', null, '3900', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-03-30 09:30:45', '0');
INSERT INTO `sys_menu` VALUES ('3700', '注册配置', null, 'nacos', '3000', 'icon-line', 'views/admin/nacos/index', '10', '0', '0', '2018-01-25 11:08:52', '2019-05-01 22:52:21', '1');
INSERT INTO `sys_menu` VALUES ('4000', '可视化', null, '/ucp', '-1', 'icon-jichuguanli', 'Layout', '3', '0', '0', '2019-07-16 14:28:00', '2019-07-16 14:29:28', '0');
INSERT INTO `sys_menu` VALUES ('4100', '用户管理5.0', null, 'ucp5.0', '4000', 'icon-yonghuguanli', 'views/ucpv5/user/index', '1', '0', '0', '2019-02-26 13:41:19', '2019-03-04 16:54:07', '0');
INSERT INTO `sys_menu` VALUES ('4101', '查看', null, null, '4100', null, null, '1', '0', '1', '2019-02-26 13:42:17', '2019-07-16 14:46:37', '0');
INSERT INTO `sys_menu` VALUES ('4102', '添加节点', 'ucp_node_addv5', null, '4100', null, null, '2', '0', '1', '2019-02-26 13:44:01', '2019-07-16 14:46:38', '0');
INSERT INTO `sys_menu` VALUES ('4103', '添加组', 'ucp_group_addv5', null, '4100', null, null, '3', '0', '1', '2019-02-26 13:45:30', '2019-07-16 14:46:39', '0');
INSERT INTO `sys_menu` VALUES ('4104', '添加用户', 'ucp_user_addv5', null, '4100', null, null, '4', '0', '1', '2019-02-26 13:46:24', '2019-07-16 14:46:40', '0');
INSERT INTO `sys_menu` VALUES ('4105', '编辑', 'ucp_update_btnv5', null, '4100', null, null, '5', '0', '1', '2019-02-26 13:48:07', '2019-07-16 14:46:40', '0');
INSERT INTO `sys_menu` VALUES ('4106', '删除', 'ucp_user_delv5', null, '4100', null, null, '6', '0', '1', '2019-02-26 13:49:17', '2019-07-16 14:46:41', '0');
INSERT INTO `sys_menu` VALUES ('4107', '权限', 'ucp_user_correlation', null, '4100', null, null, '7', '0', '1', '2019-03-19 18:17:10', '2019-07-16 14:46:43', '0');

-- ----------------------------
-- Table structure for `sys_oauth_client_details`
-- ----------------------------
DROP TABLE IF EXISTS `sys_oauth_client_details`;
CREATE TABLE `sys_oauth_client_details` (
                                          `client_id` varchar(32) NOT NULL,
                                          `resource_ids` varchar(256) DEFAULT NULL,
                                          `client_secret` varchar(256) DEFAULT NULL,
                                          `scope` varchar(256) DEFAULT NULL,
                                          `authorized_grant_types` varchar(256) DEFAULT NULL,
                                          `web_server_redirect_uri` varchar(256) DEFAULT NULL,
                                          `authorities` varchar(256) DEFAULT NULL,
                                          `access_token_validity` int(11) DEFAULT NULL,
                                          `refresh_token_validity` int(11) DEFAULT NULL,
                                          `additional_information` varchar(4096) DEFAULT NULL,
                                          `autoapprove` varchar(256) DEFAULT NULL,
                                          `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
                                          PRIMARY KEY (`client_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='终端信息表';

-- ----------------------------
-- Records of sys_oauth_client_details
-- ----------------------------
INSERT INTO `sys_oauth_client_details` VALUES ('app', null, 'app', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1');
INSERT INTO `sys_oauth_client_details` VALUES ('daemon', null, 'daemon', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1');
INSERT INTO `sys_oauth_client_details` VALUES ('gen', null, 'gen', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1');
INSERT INTO `sys_oauth_client_details` VALUES ('mp', null, 'mp', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1');
INSERT INTO `sys_oauth_client_details` VALUES ('sc', null, 'sc', 'server', 'password,refresh_token,authorization_code,client_credentials', 'http://localhost:4040/sso/login,http://localhost:4041/sso/login', null, null, null, null, 'true', '1');
INSERT INTO `sys_oauth_client_details` VALUES ('test', null, 'test', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1');

-- ----------------------------
-- Table structure for `sys_public_param`
-- ----------------------------
DROP TABLE IF EXISTS `sys_public_param`;
CREATE TABLE `sys_public_param` (
                                  `public_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
                                  `public_name` varchar(128) NOT NULL COMMENT '公共参数名称',
                                  `public_key` varchar(128) NOT NULL COMMENT '键,英文大写+下划线',
                                  `public_value` text COMMENT '值',
                                  `status` char(1) DEFAULT '1' COMMENT '状态：1有效；2无效；',
                                  `validate_code` varchar(64) DEFAULT NULL COMMENT '公共参数编码',
                                  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                  `public_type` char(1) DEFAULT '0' COMMENT '配置类型：0-默认；1-检索；2-原文；3-报表；4-安全；5-文档；6-消息；9-其他',
                                  `system` char(1) NOT NULL DEFAULT '0' COMMENT '是否是系统默认',
                                  `del_flag` char(1) DEFAULT '0' COMMENT '删除状态：0-正常；1-已删除',
                                  `tenant_id` int(11) DEFAULT NULL COMMENT '租户ID',
                                  PRIMARY KEY (`public_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='公共参数配置表';

-- ----------------------------
-- Records of sys_public_param
-- ----------------------------
INSERT INTO `sys_public_param` VALUES ('1', '系统首页参数配置', 'INDEX_MSG_CONFIG', '', '0', null, '2019-04-28 18:24:38', '2019-05-16 21:41:28', '9', '0', '0', '1');
INSERT INTO `sys_public_param` VALUES ('2', '信息说明', 'VERSION_INSTRUCTIONS', '', '0', null, '2019-04-28 18:24:38', '2019-05-16 21:41:29', '9', '0', '0', '1');
INSERT INTO `sys_public_param` VALUES ('3', '办公安全支持文件类型', 'OFFICE_SAFETY_FILETYPE', 'PDF,CEB,CEBX,DOC,DOCX,XLS,XLSX,PPT,PPTX,WPS', '0', null, '2019-04-28 18:24:38', '2019-05-16 21:41:31', '4', '0', '0', '1');

-- ----------------------------
-- Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
                          `role_id` int(11) NOT NULL AUTO_INCREMENT,
                          `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                          `role_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                          `role_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
                          `ds_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '2' COMMENT '数据权限类型',
                          `ds_scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据权限范围',
                          `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                          `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
                          `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
                          `tenant_id` int(11) DEFAULT NULL,
                          PRIMARY KEY (`role_id`) USING BTREE,
                          KEY `role_idx1_role_code` (`role_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', '管理员', 'ROLE_ADMIN', '管理员', '0', '2', '2017-10-29 15:45:51', '2018-12-26 14:09:11', '0', '1');
INSERT INTO `sys_role` VALUES ('6', '超级管理员', 'SUPER_ADMIN', '超级管理员，管理所有角色及权限,不允许删除与修改', '0', '', '2019-07-22 09:41:39', '2019-07-22 10:44:34', '0', '0');
INSERT INTO `sys_role` VALUES ('8', 'UCP_ADMIN', 'UCP_ADMIN', 'UCP角色', '0', '', '2019-07-22 14:52:05', '2019-07-22 15:10:32', '0', '5');
INSERT INTO `sys_role` VALUES ('11', 'test003', 'test003', 'test003', '0', '', '2019-07-22 17:15:37', null, '0', '5');

-- ----------------------------
-- Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
                               `role_id` int(11) NOT NULL COMMENT '角色ID',
                               `menu_id` int(11) NOT NULL COMMENT '菜单ID',
                               PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('1', '1000');
INSERT INTO `sys_role_menu` VALUES ('1', '1100');
INSERT INTO `sys_role_menu` VALUES ('1', '1101');
INSERT INTO `sys_role_menu` VALUES ('1', '1102');
INSERT INTO `sys_role_menu` VALUES ('1', '1103');
INSERT INTO `sys_role_menu` VALUES ('1', '1200');
INSERT INTO `sys_role_menu` VALUES ('1', '1201');
INSERT INTO `sys_role_menu` VALUES ('1', '1202');
INSERT INTO `sys_role_menu` VALUES ('1', '1203');
INSERT INTO `sys_role_menu` VALUES ('1', '1300');
INSERT INTO `sys_role_menu` VALUES ('1', '1301');
INSERT INTO `sys_role_menu` VALUES ('1', '1302');
INSERT INTO `sys_role_menu` VALUES ('1', '1303');
INSERT INTO `sys_role_menu` VALUES ('1', '1304');
INSERT INTO `sys_role_menu` VALUES ('1', '1400');
INSERT INTO `sys_role_menu` VALUES ('1', '1401');
INSERT INTO `sys_role_menu` VALUES ('1', '1402');
INSERT INTO `sys_role_menu` VALUES ('1', '1403');
INSERT INTO `sys_role_menu` VALUES ('1', '1500');
INSERT INTO `sys_role_menu` VALUES ('1', '1501');
INSERT INTO `sys_role_menu` VALUES ('1', '1502');
INSERT INTO `sys_role_menu` VALUES ('1', '1503');
INSERT INTO `sys_role_menu` VALUES ('1', '2000');
INSERT INTO `sys_role_menu` VALUES ('1', '2100');
INSERT INTO `sys_role_menu` VALUES ('1', '2101');
INSERT INTO `sys_role_menu` VALUES ('1', '2200');
INSERT INTO `sys_role_menu` VALUES ('1', '2201');
INSERT INTO `sys_role_menu` VALUES ('1', '2202');
INSERT INTO `sys_role_menu` VALUES ('1', '2203');
INSERT INTO `sys_role_menu` VALUES ('1', '2210');
INSERT INTO `sys_role_menu` VALUES ('1', '2211');
INSERT INTO `sys_role_menu` VALUES ('1', '2212');
INSERT INTO `sys_role_menu` VALUES ('1', '2213');
INSERT INTO `sys_role_menu` VALUES ('1', '2300');
INSERT INTO `sys_role_menu` VALUES ('1', '2400');
INSERT INTO `sys_role_menu` VALUES ('1', '2401');
INSERT INTO `sys_role_menu` VALUES ('1', '2402');
INSERT INTO `sys_role_menu` VALUES ('1', '2403');
INSERT INTO `sys_role_menu` VALUES ('1', '2500');
INSERT INTO `sys_role_menu` VALUES ('1', '2501');
INSERT INTO `sys_role_menu` VALUES ('1', '2502');
INSERT INTO `sys_role_menu` VALUES ('1', '2503');
INSERT INTO `sys_role_menu` VALUES ('1', '2600');
INSERT INTO `sys_role_menu` VALUES ('1', '2601');
INSERT INTO `sys_role_menu` VALUES ('1', '2700');
INSERT INTO `sys_role_menu` VALUES ('1', '2800');
INSERT INTO `sys_role_menu` VALUES ('1', '2810');
INSERT INTO `sys_role_menu` VALUES ('1', '2820');
INSERT INTO `sys_role_menu` VALUES ('1', '2830');
INSERT INTO `sys_role_menu` VALUES ('1', '2840');
INSERT INTO `sys_role_menu` VALUES ('1', '2850');
INSERT INTO `sys_role_menu` VALUES ('1', '2860');
INSERT INTO `sys_role_menu` VALUES ('1', '3000');
INSERT INTO `sys_role_menu` VALUES ('1', '3100');
INSERT INTO `sys_role_menu` VALUES ('1', '3110');
INSERT INTO `sys_role_menu` VALUES ('1', '3200');
INSERT INTO `sys_role_menu` VALUES ('1', '3500');
INSERT INTO `sys_role_menu` VALUES ('1', '3600');
INSERT INTO `sys_role_menu` VALUES ('1', '3601');
INSERT INTO `sys_role_menu` VALUES ('1', '3620');
INSERT INTO `sys_role_menu` VALUES ('1', '3630');
INSERT INTO `sys_role_menu` VALUES ('1', '4000');
INSERT INTO `sys_role_menu` VALUES ('1', '4100');
INSERT INTO `sys_role_menu` VALUES ('1', '4101');
INSERT INTO `sys_role_menu` VALUES ('1', '4200');
INSERT INTO `sys_role_menu` VALUES ('1', '4201');
INSERT INTO `sys_role_menu` VALUES ('1', '4300');
INSERT INTO `sys_role_menu` VALUES ('1', '4301');
INSERT INTO `sys_role_menu` VALUES ('1', '4302');
INSERT INTO `sys_role_menu` VALUES ('1', '4303');
INSERT INTO `sys_role_menu` VALUES ('1', '4400');
INSERT INTO `sys_role_menu` VALUES ('1', '4401');
INSERT INTO `sys_role_menu` VALUES ('1', '6000');
INSERT INTO `sys_role_menu` VALUES ('1', '6100');
INSERT INTO `sys_role_menu` VALUES ('1', '6101');
INSERT INTO `sys_role_menu` VALUES ('1', '6102');
INSERT INTO `sys_role_menu` VALUES ('1', '6103');
INSERT INTO `sys_role_menu` VALUES ('1', '6200');
INSERT INTO `sys_role_menu` VALUES ('1', '6201');
INSERT INTO `sys_role_menu` VALUES ('1', '6202');
INSERT INTO `sys_role_menu` VALUES ('1', '6203');
INSERT INTO `sys_role_menu` VALUES ('1', '6300');
INSERT INTO `sys_role_menu` VALUES ('1', '6301');
INSERT INTO `sys_role_menu` VALUES ('1', '6302');
INSERT INTO `sys_role_menu` VALUES ('1', '6303');
INSERT INTO `sys_role_menu` VALUES ('1', '6304');
INSERT INTO `sys_role_menu` VALUES ('1', '6305');
INSERT INTO `sys_role_menu` VALUES ('1', '6400');
INSERT INTO `sys_role_menu` VALUES ('1', '6401');
INSERT INTO `sys_role_menu` VALUES ('1', '6402');
INSERT INTO `sys_role_menu` VALUES ('1', '6500');
INSERT INTO `sys_role_menu` VALUES ('1', '9999');
INSERT INTO `sys_role_menu` VALUES ('2', '1000');
INSERT INTO `sys_role_menu` VALUES ('2', '1100');
INSERT INTO `sys_role_menu` VALUES ('2', '1101');
INSERT INTO `sys_role_menu` VALUES ('2', '1102');
INSERT INTO `sys_role_menu` VALUES ('2', '1103');
INSERT INTO `sys_role_menu` VALUES ('2', '1200');
INSERT INTO `sys_role_menu` VALUES ('2', '1201');
INSERT INTO `sys_role_menu` VALUES ('2', '1202');
INSERT INTO `sys_role_menu` VALUES ('2', '1203');
INSERT INTO `sys_role_menu` VALUES ('2', '1300');
INSERT INTO `sys_role_menu` VALUES ('2', '1301');
INSERT INTO `sys_role_menu` VALUES ('2', '1302');
INSERT INTO `sys_role_menu` VALUES ('2', '1303');
INSERT INTO `sys_role_menu` VALUES ('2', '1304');
INSERT INTO `sys_role_menu` VALUES ('2', '1400');
INSERT INTO `sys_role_menu` VALUES ('2', '1401');
INSERT INTO `sys_role_menu` VALUES ('2', '1402');
INSERT INTO `sys_role_menu` VALUES ('2', '1403');
INSERT INTO `sys_role_menu` VALUES ('2', '1500');
INSERT INTO `sys_role_menu` VALUES ('2', '1501');
INSERT INTO `sys_role_menu` VALUES ('2', '1502');
INSERT INTO `sys_role_menu` VALUES ('2', '1503');
INSERT INTO `sys_role_menu` VALUES ('2', '2000');
INSERT INTO `sys_role_menu` VALUES ('2', '2100');
INSERT INTO `sys_role_menu` VALUES ('2', '2101');
INSERT INTO `sys_role_menu` VALUES ('2', '2200');
INSERT INTO `sys_role_menu` VALUES ('2', '2201');
INSERT INTO `sys_role_menu` VALUES ('2', '2202');
INSERT INTO `sys_role_menu` VALUES ('2', '2203');
INSERT INTO `sys_role_menu` VALUES ('2', '2210');
INSERT INTO `sys_role_menu` VALUES ('2', '2211');
INSERT INTO `sys_role_menu` VALUES ('2', '2212');
INSERT INTO `sys_role_menu` VALUES ('2', '2213');
INSERT INTO `sys_role_menu` VALUES ('2', '2300');
INSERT INTO `sys_role_menu` VALUES ('2', '2400');
INSERT INTO `sys_role_menu` VALUES ('2', '2401');
INSERT INTO `sys_role_menu` VALUES ('2', '2402');
INSERT INTO `sys_role_menu` VALUES ('2', '2403');
INSERT INTO `sys_role_menu` VALUES ('2', '2500');
INSERT INTO `sys_role_menu` VALUES ('2', '2501');
INSERT INTO `sys_role_menu` VALUES ('2', '2502');
INSERT INTO `sys_role_menu` VALUES ('2', '2503');
INSERT INTO `sys_role_menu` VALUES ('2', '2600');
INSERT INTO `sys_role_menu` VALUES ('2', '2601');
INSERT INTO `sys_role_menu` VALUES ('2', '2700');
INSERT INTO `sys_role_menu` VALUES ('2', '2800');
INSERT INTO `sys_role_menu` VALUES ('2', '2810');
INSERT INTO `sys_role_menu` VALUES ('2', '2820');
INSERT INTO `sys_role_menu` VALUES ('2', '2830');
INSERT INTO `sys_role_menu` VALUES ('2', '2840');
INSERT INTO `sys_role_menu` VALUES ('2', '2850');
INSERT INTO `sys_role_menu` VALUES ('2', '2860');
INSERT INTO `sys_role_menu` VALUES ('2', '3000');
INSERT INTO `sys_role_menu` VALUES ('2', '3100');
INSERT INTO `sys_role_menu` VALUES ('2', '3110');
INSERT INTO `sys_role_menu` VALUES ('2', '3200');
INSERT INTO `sys_role_menu` VALUES ('2', '3500');
INSERT INTO `sys_role_menu` VALUES ('2', '3600');
INSERT INTO `sys_role_menu` VALUES ('2', '3601');
INSERT INTO `sys_role_menu` VALUES ('2', '3620');
INSERT INTO `sys_role_menu` VALUES ('2', '3630');
INSERT INTO `sys_role_menu` VALUES ('2', '3631');
INSERT INTO `sys_role_menu` VALUES ('2', '4000');
INSERT INTO `sys_role_menu` VALUES ('2', '4100');
INSERT INTO `sys_role_menu` VALUES ('2', '4101');
INSERT INTO `sys_role_menu` VALUES ('2', '4102');
INSERT INTO `sys_role_menu` VALUES ('2', '4103');
INSERT INTO `sys_role_menu` VALUES ('2', '4104');
INSERT INTO `sys_role_menu` VALUES ('2', '4105');
INSERT INTO `sys_role_menu` VALUES ('2', '4106');
INSERT INTO `sys_role_menu` VALUES ('2', '4107');
INSERT INTO `sys_role_menu` VALUES ('3', '1000');
INSERT INTO `sys_role_menu` VALUES ('3', '1100');
INSERT INTO `sys_role_menu` VALUES ('3', '1101');
INSERT INTO `sys_role_menu` VALUES ('3', '1102');
INSERT INTO `sys_role_menu` VALUES ('3', '1103');
INSERT INTO `sys_role_menu` VALUES ('3', '1200');
INSERT INTO `sys_role_menu` VALUES ('3', '1201');
INSERT INTO `sys_role_menu` VALUES ('3', '1202');
INSERT INTO `sys_role_menu` VALUES ('3', '1203');
INSERT INTO `sys_role_menu` VALUES ('3', '1300');
INSERT INTO `sys_role_menu` VALUES ('3', '1301');
INSERT INTO `sys_role_menu` VALUES ('3', '1302');
INSERT INTO `sys_role_menu` VALUES ('3', '1303');
INSERT INTO `sys_role_menu` VALUES ('3', '1304');
INSERT INTO `sys_role_menu` VALUES ('3', '1400');
INSERT INTO `sys_role_menu` VALUES ('3', '1401');
INSERT INTO `sys_role_menu` VALUES ('3', '1402');
INSERT INTO `sys_role_menu` VALUES ('3', '1403');
INSERT INTO `sys_role_menu` VALUES ('3', '1500');
INSERT INTO `sys_role_menu` VALUES ('3', '1501');
INSERT INTO `sys_role_menu` VALUES ('3', '1502');
INSERT INTO `sys_role_menu` VALUES ('3', '1503');
INSERT INTO `sys_role_menu` VALUES ('3', '2000');
INSERT INTO `sys_role_menu` VALUES ('3', '2100');
INSERT INTO `sys_role_menu` VALUES ('3', '2101');
INSERT INTO `sys_role_menu` VALUES ('3', '2200');
INSERT INTO `sys_role_menu` VALUES ('3', '2201');
INSERT INTO `sys_role_menu` VALUES ('3', '2202');
INSERT INTO `sys_role_menu` VALUES ('3', '2203');
INSERT INTO `sys_role_menu` VALUES ('3', '2210');
INSERT INTO `sys_role_menu` VALUES ('3', '2211');
INSERT INTO `sys_role_menu` VALUES ('3', '2212');
INSERT INTO `sys_role_menu` VALUES ('3', '2213');
INSERT INTO `sys_role_menu` VALUES ('3', '2300');
INSERT INTO `sys_role_menu` VALUES ('3', '2400');
INSERT INTO `sys_role_menu` VALUES ('3', '2401');
INSERT INTO `sys_role_menu` VALUES ('3', '2402');
INSERT INTO `sys_role_menu` VALUES ('3', '2403');
INSERT INTO `sys_role_menu` VALUES ('3', '2500');
INSERT INTO `sys_role_menu` VALUES ('3', '2501');
INSERT INTO `sys_role_menu` VALUES ('3', '2502');
INSERT INTO `sys_role_menu` VALUES ('3', '2503');
INSERT INTO `sys_role_menu` VALUES ('3', '2600');
INSERT INTO `sys_role_menu` VALUES ('3', '2601');
INSERT INTO `sys_role_menu` VALUES ('3', '2700');
INSERT INTO `sys_role_menu` VALUES ('3', '2800');
INSERT INTO `sys_role_menu` VALUES ('3', '2810');
INSERT INTO `sys_role_menu` VALUES ('3', '2820');
INSERT INTO `sys_role_menu` VALUES ('3', '2830');
INSERT INTO `sys_role_menu` VALUES ('3', '2840');
INSERT INTO `sys_role_menu` VALUES ('3', '2850');
INSERT INTO `sys_role_menu` VALUES ('3', '2860');
INSERT INTO `sys_role_menu` VALUES ('3', '3000');
INSERT INTO `sys_role_menu` VALUES ('3', '3100');
INSERT INTO `sys_role_menu` VALUES ('3', '3110');
INSERT INTO `sys_role_menu` VALUES ('3', '3200');
INSERT INTO `sys_role_menu` VALUES ('3', '3500');
INSERT INTO `sys_role_menu` VALUES ('3', '3600');
INSERT INTO `sys_role_menu` VALUES ('3', '3601');
INSERT INTO `sys_role_menu` VALUES ('3', '3620');
INSERT INTO `sys_role_menu` VALUES ('3', '3630');
INSERT INTO `sys_role_menu` VALUES ('3', '3631');
INSERT INTO `sys_role_menu` VALUES ('3', '4000');
INSERT INTO `sys_role_menu` VALUES ('3', '4100');
INSERT INTO `sys_role_menu` VALUES ('3', '4101');
INSERT INTO `sys_role_menu` VALUES ('3', '4102');
INSERT INTO `sys_role_menu` VALUES ('3', '4103');
INSERT INTO `sys_role_menu` VALUES ('3', '4104');
INSERT INTO `sys_role_menu` VALUES ('3', '4105');
INSERT INTO `sys_role_menu` VALUES ('3', '4106');
INSERT INTO `sys_role_menu` VALUES ('3', '4107');
INSERT INTO `sys_role_menu` VALUES ('4', '1000');
INSERT INTO `sys_role_menu` VALUES ('4', '1100');
INSERT INTO `sys_role_menu` VALUES ('4', '1101');
INSERT INTO `sys_role_menu` VALUES ('4', '1102');
INSERT INTO `sys_role_menu` VALUES ('4', '1103');
INSERT INTO `sys_role_menu` VALUES ('4', '1200');
INSERT INTO `sys_role_menu` VALUES ('4', '1201');
INSERT INTO `sys_role_menu` VALUES ('4', '1202');
INSERT INTO `sys_role_menu` VALUES ('4', '1203');
INSERT INTO `sys_role_menu` VALUES ('4', '1300');
INSERT INTO `sys_role_menu` VALUES ('4', '1301');
INSERT INTO `sys_role_menu` VALUES ('4', '1302');
INSERT INTO `sys_role_menu` VALUES ('4', '1303');
INSERT INTO `sys_role_menu` VALUES ('4', '1304');
INSERT INTO `sys_role_menu` VALUES ('4', '1400');
INSERT INTO `sys_role_menu` VALUES ('4', '1401');
INSERT INTO `sys_role_menu` VALUES ('4', '1402');
INSERT INTO `sys_role_menu` VALUES ('4', '1403');
INSERT INTO `sys_role_menu` VALUES ('4', '1500');
INSERT INTO `sys_role_menu` VALUES ('4', '1501');
INSERT INTO `sys_role_menu` VALUES ('4', '1502');
INSERT INTO `sys_role_menu` VALUES ('4', '1503');
INSERT INTO `sys_role_menu` VALUES ('4', '2000');
INSERT INTO `sys_role_menu` VALUES ('4', '2100');
INSERT INTO `sys_role_menu` VALUES ('4', '2101');
INSERT INTO `sys_role_menu` VALUES ('4', '2200');
INSERT INTO `sys_role_menu` VALUES ('4', '2201');
INSERT INTO `sys_role_menu` VALUES ('4', '2202');
INSERT INTO `sys_role_menu` VALUES ('4', '2203');
INSERT INTO `sys_role_menu` VALUES ('4', '2210');
INSERT INTO `sys_role_menu` VALUES ('4', '2211');
INSERT INTO `sys_role_menu` VALUES ('4', '2212');
INSERT INTO `sys_role_menu` VALUES ('4', '2213');
INSERT INTO `sys_role_menu` VALUES ('4', '2300');
INSERT INTO `sys_role_menu` VALUES ('4', '2400');
INSERT INTO `sys_role_menu` VALUES ('4', '2401');
INSERT INTO `sys_role_menu` VALUES ('4', '2402');
INSERT INTO `sys_role_menu` VALUES ('4', '2403');
INSERT INTO `sys_role_menu` VALUES ('4', '2500');
INSERT INTO `sys_role_menu` VALUES ('4', '2501');
INSERT INTO `sys_role_menu` VALUES ('4', '2502');
INSERT INTO `sys_role_menu` VALUES ('4', '2503');
INSERT INTO `sys_role_menu` VALUES ('4', '2600');
INSERT INTO `sys_role_menu` VALUES ('4', '2601');
INSERT INTO `sys_role_menu` VALUES ('4', '2700');
INSERT INTO `sys_role_menu` VALUES ('4', '2800');
INSERT INTO `sys_role_menu` VALUES ('4', '2810');
INSERT INTO `sys_role_menu` VALUES ('4', '2820');
INSERT INTO `sys_role_menu` VALUES ('4', '2830');
INSERT INTO `sys_role_menu` VALUES ('4', '2840');
INSERT INTO `sys_role_menu` VALUES ('4', '2850');
INSERT INTO `sys_role_menu` VALUES ('4', '2860');
INSERT INTO `sys_role_menu` VALUES ('4', '3000');
INSERT INTO `sys_role_menu` VALUES ('4', '3100');
INSERT INTO `sys_role_menu` VALUES ('4', '3110');
INSERT INTO `sys_role_menu` VALUES ('4', '3200');
INSERT INTO `sys_role_menu` VALUES ('4', '3500');
INSERT INTO `sys_role_menu` VALUES ('4', '3600');
INSERT INTO `sys_role_menu` VALUES ('4', '3601');
INSERT INTO `sys_role_menu` VALUES ('4', '3620');
INSERT INTO `sys_role_menu` VALUES ('4', '3630');
INSERT INTO `sys_role_menu` VALUES ('4', '3631');
INSERT INTO `sys_role_menu` VALUES ('4', '4000');
INSERT INTO `sys_role_menu` VALUES ('4', '4100');
INSERT INTO `sys_role_menu` VALUES ('4', '4101');
INSERT INTO `sys_role_menu` VALUES ('4', '4102');
INSERT INTO `sys_role_menu` VALUES ('4', '4103');
INSERT INTO `sys_role_menu` VALUES ('4', '4104');
INSERT INTO `sys_role_menu` VALUES ('4', '4105');
INSERT INTO `sys_role_menu` VALUES ('4', '4106');
INSERT INTO `sys_role_menu` VALUES ('4', '4107');
INSERT INTO `sys_role_menu` VALUES ('6', '1000');
INSERT INTO `sys_role_menu` VALUES ('6', '1100');
INSERT INTO `sys_role_menu` VALUES ('6', '1101');
INSERT INTO `sys_role_menu` VALUES ('6', '1102');
INSERT INTO `sys_role_menu` VALUES ('6', '1103');
INSERT INTO `sys_role_menu` VALUES ('6', '1200');
INSERT INTO `sys_role_menu` VALUES ('6', '1201');
INSERT INTO `sys_role_menu` VALUES ('6', '1202');
INSERT INTO `sys_role_menu` VALUES ('6', '1203');
INSERT INTO `sys_role_menu` VALUES ('6', '1300');
INSERT INTO `sys_role_menu` VALUES ('6', '1301');
INSERT INTO `sys_role_menu` VALUES ('6', '1302');
INSERT INTO `sys_role_menu` VALUES ('6', '1303');
INSERT INTO `sys_role_menu` VALUES ('6', '1304');
INSERT INTO `sys_role_menu` VALUES ('6', '1400');
INSERT INTO `sys_role_menu` VALUES ('6', '1401');
INSERT INTO `sys_role_menu` VALUES ('6', '1402');
INSERT INTO `sys_role_menu` VALUES ('6', '1403');
INSERT INTO `sys_role_menu` VALUES ('6', '1500');
INSERT INTO `sys_role_menu` VALUES ('6', '1501');
INSERT INTO `sys_role_menu` VALUES ('6', '1502');
INSERT INTO `sys_role_menu` VALUES ('6', '1503');
INSERT INTO `sys_role_menu` VALUES ('6', '2000');
INSERT INTO `sys_role_menu` VALUES ('6', '2100');
INSERT INTO `sys_role_menu` VALUES ('6', '2101');
INSERT INTO `sys_role_menu` VALUES ('6', '2200');
INSERT INTO `sys_role_menu` VALUES ('6', '2201');
INSERT INTO `sys_role_menu` VALUES ('6', '2202');
INSERT INTO `sys_role_menu` VALUES ('6', '2203');
INSERT INTO `sys_role_menu` VALUES ('6', '2210');
INSERT INTO `sys_role_menu` VALUES ('6', '2211');
INSERT INTO `sys_role_menu` VALUES ('6', '2212');
INSERT INTO `sys_role_menu` VALUES ('6', '2213');
INSERT INTO `sys_role_menu` VALUES ('6', '2300');
INSERT INTO `sys_role_menu` VALUES ('6', '2400');
INSERT INTO `sys_role_menu` VALUES ('6', '2401');
INSERT INTO `sys_role_menu` VALUES ('6', '2402');
INSERT INTO `sys_role_menu` VALUES ('6', '2403');
INSERT INTO `sys_role_menu` VALUES ('6', '2500');
INSERT INTO `sys_role_menu` VALUES ('6', '2501');
INSERT INTO `sys_role_menu` VALUES ('6', '2502');
INSERT INTO `sys_role_menu` VALUES ('6', '2503');
INSERT INTO `sys_role_menu` VALUES ('6', '2600');
INSERT INTO `sys_role_menu` VALUES ('6', '2601');
INSERT INTO `sys_role_menu` VALUES ('6', '2700');
INSERT INTO `sys_role_menu` VALUES ('6', '2800');
INSERT INTO `sys_role_menu` VALUES ('6', '2810');
INSERT INTO `sys_role_menu` VALUES ('6', '2820');
INSERT INTO `sys_role_menu` VALUES ('6', '2830');
INSERT INTO `sys_role_menu` VALUES ('6', '2840');
INSERT INTO `sys_role_menu` VALUES ('6', '2850');
INSERT INTO `sys_role_menu` VALUES ('6', '2860');
INSERT INTO `sys_role_menu` VALUES ('6', '3000');
INSERT INTO `sys_role_menu` VALUES ('6', '3100');
INSERT INTO `sys_role_menu` VALUES ('6', '3110');
INSERT INTO `sys_role_menu` VALUES ('6', '3200');
INSERT INTO `sys_role_menu` VALUES ('6', '3500');
INSERT INTO `sys_role_menu` VALUES ('6', '3600');
INSERT INTO `sys_role_menu` VALUES ('6', '3601');
INSERT INTO `sys_role_menu` VALUES ('6', '3620');
INSERT INTO `sys_role_menu` VALUES ('6', '3630');
INSERT INTO `sys_role_menu` VALUES ('6', '4000');
INSERT INTO `sys_role_menu` VALUES ('6', '4100');
INSERT INTO `sys_role_menu` VALUES ('6', '4101');
INSERT INTO `sys_role_menu` VALUES ('6', '4102');
INSERT INTO `sys_role_menu` VALUES ('6', '4103');
INSERT INTO `sys_role_menu` VALUES ('6', '4104');
INSERT INTO `sys_role_menu` VALUES ('6', '4105');
INSERT INTO `sys_role_menu` VALUES ('6', '4106');
INSERT INTO `sys_role_menu` VALUES ('6', '4107');
INSERT INTO `sys_role_menu` VALUES ('7', '1000');
INSERT INTO `sys_role_menu` VALUES ('7', '1100');
INSERT INTO `sys_role_menu` VALUES ('7', '1101');
INSERT INTO `sys_role_menu` VALUES ('7', '1102');
INSERT INTO `sys_role_menu` VALUES ('7', '1103');
INSERT INTO `sys_role_menu` VALUES ('7', '1200');
INSERT INTO `sys_role_menu` VALUES ('7', '1201');
INSERT INTO `sys_role_menu` VALUES ('7', '1202');
INSERT INTO `sys_role_menu` VALUES ('7', '1203');
INSERT INTO `sys_role_menu` VALUES ('7', '1300');
INSERT INTO `sys_role_menu` VALUES ('7', '1301');
INSERT INTO `sys_role_menu` VALUES ('7', '1302');
INSERT INTO `sys_role_menu` VALUES ('7', '1303');
INSERT INTO `sys_role_menu` VALUES ('7', '1304');
INSERT INTO `sys_role_menu` VALUES ('7', '1400');
INSERT INTO `sys_role_menu` VALUES ('7', '1401');
INSERT INTO `sys_role_menu` VALUES ('7', '1402');
INSERT INTO `sys_role_menu` VALUES ('7', '1403');
INSERT INTO `sys_role_menu` VALUES ('7', '1500');
INSERT INTO `sys_role_menu` VALUES ('7', '1501');
INSERT INTO `sys_role_menu` VALUES ('7', '1502');
INSERT INTO `sys_role_menu` VALUES ('7', '1503');
INSERT INTO `sys_role_menu` VALUES ('7', '2000');
INSERT INTO `sys_role_menu` VALUES ('7', '2100');
INSERT INTO `sys_role_menu` VALUES ('7', '2101');
INSERT INTO `sys_role_menu` VALUES ('7', '2200');
INSERT INTO `sys_role_menu` VALUES ('7', '2201');
INSERT INTO `sys_role_menu` VALUES ('7', '2202');
INSERT INTO `sys_role_menu` VALUES ('7', '2203');
INSERT INTO `sys_role_menu` VALUES ('7', '2210');
INSERT INTO `sys_role_menu` VALUES ('7', '2211');
INSERT INTO `sys_role_menu` VALUES ('7', '2212');
INSERT INTO `sys_role_menu` VALUES ('7', '2213');
INSERT INTO `sys_role_menu` VALUES ('7', '2300');
INSERT INTO `sys_role_menu` VALUES ('7', '2400');
INSERT INTO `sys_role_menu` VALUES ('7', '2401');
INSERT INTO `sys_role_menu` VALUES ('7', '2402');
INSERT INTO `sys_role_menu` VALUES ('7', '2403');
INSERT INTO `sys_role_menu` VALUES ('7', '2500');
INSERT INTO `sys_role_menu` VALUES ('7', '2501');
INSERT INTO `sys_role_menu` VALUES ('7', '2502');
INSERT INTO `sys_role_menu` VALUES ('7', '2503');
INSERT INTO `sys_role_menu` VALUES ('7', '2600');
INSERT INTO `sys_role_menu` VALUES ('7', '2601');
INSERT INTO `sys_role_menu` VALUES ('7', '2700');
INSERT INTO `sys_role_menu` VALUES ('7', '2800');
INSERT INTO `sys_role_menu` VALUES ('7', '2810');
INSERT INTO `sys_role_menu` VALUES ('7', '2820');
INSERT INTO `sys_role_menu` VALUES ('7', '2830');
INSERT INTO `sys_role_menu` VALUES ('7', '2840');
INSERT INTO `sys_role_menu` VALUES ('7', '2850');
INSERT INTO `sys_role_menu` VALUES ('7', '2860');
INSERT INTO `sys_role_menu` VALUES ('7', '3000');
INSERT INTO `sys_role_menu` VALUES ('7', '3100');
INSERT INTO `sys_role_menu` VALUES ('7', '3110');
INSERT INTO `sys_role_menu` VALUES ('7', '3200');
INSERT INTO `sys_role_menu` VALUES ('7', '3500');
INSERT INTO `sys_role_menu` VALUES ('7', '3600');
INSERT INTO `sys_role_menu` VALUES ('7', '3601');
INSERT INTO `sys_role_menu` VALUES ('7', '3620');
INSERT INTO `sys_role_menu` VALUES ('7', '3630');
INSERT INTO `sys_role_menu` VALUES ('7', '3631');
INSERT INTO `sys_role_menu` VALUES ('7', '4000');
INSERT INTO `sys_role_menu` VALUES ('7', '4100');
INSERT INTO `sys_role_menu` VALUES ('7', '4101');
INSERT INTO `sys_role_menu` VALUES ('7', '4102');
INSERT INTO `sys_role_menu` VALUES ('7', '4103');
INSERT INTO `sys_role_menu` VALUES ('7', '4104');
INSERT INTO `sys_role_menu` VALUES ('7', '4105');
INSERT INTO `sys_role_menu` VALUES ('7', '4106');
INSERT INTO `sys_role_menu` VALUES ('7', '4107');
INSERT INTO `sys_role_menu` VALUES ('8', '1000');
INSERT INTO `sys_role_menu` VALUES ('8', '1100');
INSERT INTO `sys_role_menu` VALUES ('8', '1101');
INSERT INTO `sys_role_menu` VALUES ('8', '1102');
INSERT INTO `sys_role_menu` VALUES ('8', '1103');
INSERT INTO `sys_role_menu` VALUES ('8', '1200');
INSERT INTO `sys_role_menu` VALUES ('8', '1201');
INSERT INTO `sys_role_menu` VALUES ('8', '1202');
INSERT INTO `sys_role_menu` VALUES ('8', '1203');
INSERT INTO `sys_role_menu` VALUES ('8', '1300');
INSERT INTO `sys_role_menu` VALUES ('8', '1301');
INSERT INTO `sys_role_menu` VALUES ('8', '1302');
INSERT INTO `sys_role_menu` VALUES ('8', '1303');
INSERT INTO `sys_role_menu` VALUES ('8', '1304');
INSERT INTO `sys_role_menu` VALUES ('8', '1400');
INSERT INTO `sys_role_menu` VALUES ('8', '1401');
INSERT INTO `sys_role_menu` VALUES ('8', '1402');
INSERT INTO `sys_role_menu` VALUES ('8', '1403');
INSERT INTO `sys_role_menu` VALUES ('8', '2000');
INSERT INTO `sys_role_menu` VALUES ('8', '2200');
INSERT INTO `sys_role_menu` VALUES ('8', '2201');
INSERT INTO `sys_role_menu` VALUES ('8', '2202');
INSERT INTO `sys_role_menu` VALUES ('8', '2203');
INSERT INTO `sys_role_menu` VALUES ('8', '4000');
INSERT INTO `sys_role_menu` VALUES ('8', '4100');
INSERT INTO `sys_role_menu` VALUES ('8', '4101');
INSERT INTO `sys_role_menu` VALUES ('8', '4102');
INSERT INTO `sys_role_menu` VALUES ('8', '4103');
INSERT INTO `sys_role_menu` VALUES ('8', '4104');
INSERT INTO `sys_role_menu` VALUES ('8', '4105');
INSERT INTO `sys_role_menu` VALUES ('8', '4106');
INSERT INTO `sys_role_menu` VALUES ('8', '4107');


DROP TABLE IF EXISTS `sys_route_conf`;
CREATE TABLE `sys_route_conf` (
                                `id` INT (11) NOT NULL AUTO_INCREMENT COMMENT '主键',
                                `route_name` VARCHAR (30) DEFAULT NULL COMMENT '路由名称',
                                `route_id` VARCHAR (30) NOT NULL DEFAULT '' COMMENT '路由ID',
                                `predicates` json DEFAULT NULL COMMENT '断言',
                                `filters` json DEFAULT NULL COMMENT '过滤器',
                                `uri` VARCHAR (50) DEFAULT NULL,
                                `order` INT (2) DEFAULT '0' COMMENT '排序',
                                `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                `del_flag` CHAR (1) DEFAULT '0' COMMENT '删除标记',
                                PRIMARY KEY (`id`) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 12 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMMENT = '路由配置表';
-- ----------------------------
--  Records of `sys_route_conf`
-- ----------------------------
BEGIN;
INSERT INTO `sys_route_conf` VALUES ( '2', '认证中心', 'sc-auth', '[{\"args\": {\"_genkey_0\": \"/auth/**\"}, \"name\": \"Path\"}]', '[{\"args\": {}, \"name\": \"ValidateCodeGatewayFilter\"}, {\"args\": {}, \"name\": \"PasswordDecoderFilter\"}]', 'lb://sc-auth', '0', '2019-05-09 00:23:08', '2019-05-18 15:16:25', '0' ), ( '3', '代码生成模块', 'sc-codegen', '[{\"args\": {\"_genkey_0\": \"/gen/**\"}, \"name\": \"Path\"}]', '[]', 'lb://sc-codegen', '0', '2019-05-09 00:23:08', '2019-05-18 15:16:28', '0' ), ( '5', 'quartz定时任务模块', 'sc-daemon-quartz', '[{\"args\": {\"_genkey_0\": \"/job/**\"}, \"name\": \"Path\"}]', '[]', 'lb://sc-daemon-quartz', '0', '2019-05-09 00:23:08', '2019-05-18 15:16:33', '0' ), ( '6', 'ucp5.0', 'sc-ucp-v5', '[{\"args\": {\"_genkey_0\": \"/ucpv5/**\"}, \"name\": \"Path\"}]', '[]', 'lb://sc-ucp-v5', '0', '2019-05-09 00:23:08', '2019-05-18 15:16:35', '0' ), ( '7', '通用权限模块', 'sc-upms-biz', '[{\"args\": {\"_genkey_0\": \"/admin/**\"}, \"name\": \"Path\"}]', '[{\"args\": {\"key-resolver\": \"#{@remoteAddrKeyResolver}\", \"redis-rate-limiter.burstCapacity\": \"20\", \"redis-rate-limiter.replenishRate\": \"10\"}, \"name\": \"RequestRateLimiter\"}, {\"args\": {\"name\": \"default\", \"fallbackUri\": \"forward:/fallback\"}, \"name\": \"Hystrix\"}]', 'lb://sc-upms-biz', '0', '2019-05-09 00:23:08', '2019-05-18 15:16:43', '0' ), ( '1', '监控管理', 'sc-monitor', '[{\"args\": {\"_genkey_0\": \"/monitor/**\"}, \"name\": \"Path\"}]', '[]', 'lb://sc-monitor', '0', '2019-05-09 00:23:08', '2019-05-18 15:16:55', '0' );
COMMIT;

-- ----------------------------
-- Table structure for `sys_social_details`
-- ----------------------------
DROP TABLE IF EXISTS `sys_social_details`;
CREATE TABLE `sys_social_details` (
                                    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
                                    `type` varchar(16) NOT NULL COMMENT '类型',
                                    `remark` varchar(64) DEFAULT NULL COMMENT '描述',
                                    `app_id` varchar(64) NOT NULL COMMENT 'appid',
                                    `app_secret` varchar(64) NOT NULL COMMENT 'app_secret',
                                    `redirect_url` varchar(128) DEFAULT NULL COMMENT '回调地址',
                                    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
                                    `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
                                    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统社交登录账号表';

-- ----------------------------
-- Records of sys_social_details
-- ----------------------------
INSERT INTO `sys_social_details` VALUES ('1', 'WX', '微信互联参数', 'appid', 'appSecret', 'daoweicloud.com', '2018-08-16 14:24:25', '2019-03-02 09:43:13', '0', '1');

-- ----------------------------
-- Table structure for `sys_tenant`
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
                            `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '租户id',
                            `name` varchar(255) DEFAULT NULL COMMENT '租户名称',
                            `code` varchar(64) DEFAULT NULL COMMENT '租户编号',
                            `start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
                            `end_time` timestamp NULL DEFAULT NULL COMMENT '结束时间',
                            `status` char(1) NOT NULL DEFAULT '0' COMMENT '0正常 9-冻结',
                            `del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
                            `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建',
                            `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='租户表';

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
INSERT INTO `sys_tenant` VALUES ('1', 'upms系统标识', '1', '2019-05-15 00:00:00', '2020-05-15 00:00:00', '0', '0', '2019-05-15 15:44:57', '2019-07-19 16:05:23');
INSERT INTO `sys_tenant` VALUES ('3', 'ucp系统标识', '5', '2019-07-19 00:00:00', '2025-01-01 00:00:00', '0', '0', '2019-07-19 15:24:43', '2019-07-19 15:28:09');

-- ----------------------------
-- Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
                          `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                          `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
                          `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
                          `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '随机盐',
                          `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '简介',
                          `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
                          `dept_id` int(11) DEFAULT NULL COMMENT '部门ID',
                          `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                          `lock_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '0-正常，9-锁定',
                          `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '0-正常，1-删除',
                          `wx_openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信openid',
                          `qq_openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'QQ openid',
                          `gitee_login` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
                          `osc_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
                          `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
                          `ucp_id` varchar(34) COLLATE utf8mb4_bin DEFAULT NULL,
                          PRIMARY KEY (`user_id`) USING BTREE,
                          KEY `user_wx_openid` (`wx_openid`) USING BTREE,
                          KEY `user_qq_openid` (`qq_openid`) USING BTREE,
                          KEY `user_idx1_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'admin', '$2a$10$QOfWxxFyAMmEEmnuw9UI/..1s4B4eF/u9PzE2ZaGO.ij9YfmcUy.u', '', '17034642889', '5b87318016954b6384e07ce10ba45030.jpg', '1', '2018-04-20 07:15:18', '2019-07-19 15:21:02', '0', '0', 'o_0FT0uyg_H1vVy2H0JpSwlVGhWQ', null, null, null, '1', null);
INSERT INTO `sys_user` VALUES ('7', 'superadmin', '$2a$10$Cv4IF0sq4ekM0C9/LVxxNudCOSekeQx1c2iyMvUJyE.QDsGOzT05m', null, '', null, '0', '2019-07-22 09:47:41', '2019-07-22 11:39:18', '0', '0', null, null, null, null, '0', null);
INSERT INTO `sys_user` VALUES ('8', 'ucpadmin', '$2a$10$JV26xudZu8Modoc2mPbdJu6LqsUUhvVwVO3oxKRmKLjIow/XxB46e', null, '', null, '31', '2019-07-22 14:52:37', '2019-07-22 16:44:56', '0', '0', null, null, null, null, '5', null);
INSERT INTO `sys_user` VALUES ('9', 'test001', '$2a$10$MaTyD/6Iu57Ph.T5NUifHuVlP0Zz9VS6rKojyDdIeL3fA6C6.zi1O', null, '', null, '31', '2019-07-22 15:45:55', null, '0', '0', null, null, null, null, '5', null);
INSERT INTO `sys_user` VALUES ('10', 'test003', '$2a$10$V4UtsukevYtw7DhvjLe0n.DiHbbN4rtdj9EZW8/Br44i9aBjwuzlC', null, '', null, '33', '2019-07-22 17:16:32', null, '0', '0', null, null, null, null, '5', null);

-- ----------------------------
-- Table structure for `sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
                               `user_id` int(11) NOT NULL COMMENT '用户ID',
                               `role_id` int(11) NOT NULL COMMENT '角色ID',
                               PRIMARY KEY (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('1', '1');
INSERT INTO `sys_user_role` VALUES ('2', '2');
INSERT INTO `sys_user_role` VALUES ('3', '3');
INSERT INTO `sys_user_role` VALUES ('4', '4');
INSERT INTO `sys_user_role` VALUES ('5', '5');
INSERT INTO `sys_user_role` VALUES ('6', '7');
INSERT INTO `sys_user_role` VALUES ('7', '6');
INSERT INTO `sys_user_role` VALUES ('8', '8');
INSERT INTO `sys_user_role` VALUES ('9', '8');
INSERT INTO `sys_user_role` VALUES ('10', '11');


